Help with an expression

[MarySan1]

Help! I am trying to run a query that will give me customers who have a last order date of say January 2002. I am using the Access template Order Entry. I need to know what expression I can use to retreive these records. What I am doing right now in my query is putting the order date as between certain dates, but the customers that are coming up, still have some orders after that date. I really need help with this!

 

[David R]

Are you trying to gather just January 2002, or what are you entering as your parameter? I think we need a bit more information.

Also tell us what your criteria currently looks like. It's hard to give too much information about a problem here. Use the 'Post Reply' button on this topic.

Good luck,
David R

 

[rhounsome]

In your query try putting under the Order Date section in Criteria

Between [Enter Start Date] AND [Enter Finish Date]

This should display only dates between the set criteria.