Latest equipment settings

[Guest]

I need to track equipment settings and changes for our plant. Each
piece of equipment will have several setups, and each setup will have 28
different settings. Right now I have a table for all the equipment with an
ID, description and a few other fields. A also have a table to track the
changes with equipment id, setup number, setting type, new value, and date.
Is this the best way to structure my tables? Also, how can I create a query
to retrieve the most current settings for each setup on a specific equipment
id?

 

[[MVP] S.Clark]

Trying reading through this info and see if it helps.

http://www.mvps.org/access/queries/qry0020.htm

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Works like a charm. I did have the DMax() function in the where clause, but
this is considerably faster. Thanks.