Autolookup query w/ date range

[misssoysauce]

I want to create a table or query where, based on the calendar month, a set fuel price will be called up.

I created the table with the monthly prices as just one entry per month--which defaults to the 1st of the month.

When I run the autolookup query, the fuel prices are generated, but *only* for entries which are dated to the 1st of each month.

Question: how do I make the query encompass the range of dates within a calendar month? This system would work in excel. I don't want to add date fields for the entire year if there is a way around it.

Cheers.

 

[alvechurchdata]

how do I make the query encompass the range of dates within a calendar month?

The Month() function will give you the month number of a date so this ought to stop the lookup going for the first of the month.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[misssoysauce]

I'm confused! How exactly do I apply the Month function to this query??

 

[misssoysauce]

Also, I need it to recognize the year. I created another query to do the month function but it will not distinguish between July 04 and July 05--which is a big problem.

Any ideas?