Hello,
I have a database with 2 tables. In one table, the Part Number is displayed. In another query, the Revision Letter is displayed (many revisions to one part number). My first problem was to run a query so the latest part number and revision is displayed. I used the Totals button and added "Max" to the Total section under Revision. That worked!
Now there's another hitch. In the table displaying the Part Number, I have a field displaying the Lifecycle of the product. I need to sort this original query using criteria in the Lifecycle field. That seems to work as well. As soon as I add another field from my table (for instance, Writer), it's almost like it overrides the Max total because I am back to getting multiple part numbers again.
Table 1
Part Number Lifecycle
123456 LC30
124568 LC10
124578 LC30
Table 2
Part Number Revision Writer
123456 A Anne
123456 B Anne
124568 A Anne
124568 B Vince
124568 C Lucy
124578 A Lucy
124578 B Anne
Any ideas?
Thanks in advance,
Anne