ASk : Query result for Latest Date (1 Viewer)

[sandy70]

hi , i try to make a query that can show me data from the lastest and max date from the table i have ( see attchment file )

I try using max but still the result is not what i am looking for

Anybody can help me ???

 

[pr2-eugin]

Are you trying to get the Max of one record in a Group? If so, check this thread, it might interest you..

 

[sandy70]

Are you trying to get the Max of one record in a Group? If so, check this thread, it might interest you..

tq for your help , i got it but its look so messy

 

[pr2-eugin]

Could you in simple English, explain what you wish to involve in the Query..

Could you please define Lastest and Max of a product??

You have some data which makes no sense to me.. What is that I am supposed to look at on the DB ??

 

[Brianwarnock]

Sandy you do not need to create alias X Product & date as you can join Q 10 back to the table on Date and Product, just make the two joins.

Brian

 

[Brianwarnock]

As a secondary issue avoid spaces and special haracters in names as it will make coding simpler and allow ACCESS to check syntax in some circumstaces.
If you don't like Q10 you can use the underscore Q_10

Brian

 

[sandy70]

Sandy you do not need to create alias X Product & date as you can join Q 10 back to the table on Date and Product, just make the two joins.

Brian

ups , i always forget about its