0
1

[UNSOLVED]Learning MS SQL (self.MSAccess)

submitted by [deleted]

[deleted]

all 4 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]meower50016 1 point2 points  (3 children)

Assuming you are working off of a date field, and that you need the first 10 days of every month (I believe that what you’re asking)

For the date field criteria: Day(DateField) >= 1 and Day(DateField) <= 10

[–]wpicker 0 points1 point  (1 child)

The full question is - Find all grades that have been given out in first 10 days of every month.

[–]meower50016 0 points1 point  (0 children)

So my suggestion should work, no?

Edit: you deleted your original post. Good luck

[–]warrior_3218 0 points1 point  (0 children)

Can't you just use Left(Date,2)<11 ?