Complex Query?

[stanger1]

I am having some problems creating a query that will produce the results I am looking for. Here is the problem. I have a table called test. I want to query Cert_no, Serial_no, Weight_no and retest_no. The query will produce a report that will show all Serial_no, Weight_no and retest_no for the Cert_no. There will be several Weight_no for every Serial_no and several Serial_no for every Cert_no. I want to be able to show the highest retest_no for each Weight_no.
Any help would be greatly appreciated!

 

[gblack]

ah

If you want to create a report, why don't you use access' reporting tools to group this stuff as you have stated.

Create a simple query with all the info you need, then make a report from it using the sorting and grouping tool.

Play with it a bit and I think you will be able to do what you want here

Anyway thats what I'd do.

 

[stanger1]

gblack,

Thanks for the response! I am actually trying to find the highest retest_no for each weight_no. I can group each of the fields, but for some reason I am unable to show just the highest retest_no for each of the Weight_no.

 

[gblack]

Use the MAX function in your grouping...I think you can do this in an unbound field...can't you? Anyone?

 

[stanger1]

gblack,


I got it to work! Thanks for your help.