Access filters question 1

[wreikun]

Hello. I have a question about filters and sorting data in MS Access XP.

In my table, I have the following column titles:

Supplier (text)
Month (Jan-Dec text)
Day (number)
Year (number)
Commodity (text)
Containers (number)

Now, How do I list all commodities sent from January 10 to January 20?

I have been using 'Filter by form' but I am only able to put in a single date, such as 'January 10'. I tried putting in '10-20' in the Day field and other alternate guesses, but to no avail.

I just started using Access today and would appreciate any help.

Thanks!

-W

 

[orna]

The filter for the Day field: between 10 and 20

 

[wreikun]

Thank you orna! Also, do you know of an online reference where I can look up proper syntax I can use in Access?

Thanks again.

-W

 

[PHV]

do you know of an online reference where I can look up proper syntax I can use in Access
You may try asking the help wizard with the F1 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244