Difficult query need help

[ts568]

Hello, this time,

I have an entity called SUPPLIERSHIP
there are 3 tables/attributes:

dateCanBeShipped
supplierName
and
productType

I need to make a query that allows me to enter in a month, either into the query, or even better, a box pops up for me to enter it in.

When I have entered in the month, the search query has to search through my entity and show me all of the suppliers who can supply me with the product SAUSSAGES on the month I have specified.

I have spent just over an hour on this so far, and don't seem do be getting anywhere.

 

[cyndieking]

In the criteria line for the date field try:

Month([FieldName]) = [Enter Month]

When it asks you to enter a month enter it using the numbers 1 thru 12 (1=January, 2=February, etc.).

 

[ts568]

Thanks for the reply,
Would your idea still work if my date format is day/month/year?
e.g. today = 09/05/2007
Or would I have to enter in '01' as opposed to '1'

 

[randy700]

Numerically speaking, 01 and 1 are the same thing.


Randy

 

[JerryKlmns]

And just to mention, that all years till now have one instance of January = 1 ! And that goes for the rest of the months

Wouldn't you need the year also?