Query-Tastic! Now here's a question worth answering :)

[Benjamin Bolduc]

Hi everyone!

I'm having some trouble with a fairly simple query I'm working on for some production records. I have a field in my Prod table named [DateID]. Basically, any new day that production records are entered, they will get the same DateID. (This is just to keep them in order since we don't enter the records on a fixed schedule). So this is basically what my records look like:


Date Cases DateID
1/24 55 1
1/24 76 1
2/7 37 2
2/7 61 2


I need to query these results by the last date group that was entered. So in this case I would need only the records from 2/7. I tried to query it by week# and a Between expression, but it doesnt work cuz sometimes there are more than one date group in a week and sometimes there's only one a month.

Ok, Im rambling. basically I need an expression in my query that says:

"Take the last date entered and give only those results" then I can put a "-1" or "-2" next to it to call up previous date groups.

I hope this makes sense. If anyone could help me, I'd reaaaally appreciate it. Thanks! You guys are the best!

 

[Jon K]

Try this criteria in the DateID column in the query grid:-

In (Select Max([DateID]) from Prod)

 

[Benjamin Bolduc]

Thank you so much for your swift response! That worked perfectly. Three cheers for Jon K!