multiple items with a twist

J

Jonell

My question is: I have 3 records that have the exact same # with the end
letter being different to distinguish the difference. ( They are companion
records) How do I create a query that show all 3 companion records and the
most recent event for them?
Thanks in Advance
 
J

Jeff Boyce

Use a query.

In the selection criterion, put something like:

Like 12345 & "*"

(use the 'exact same #' in place of "12345" ... if you want to do this
repeatedly for different numbers, use a parameter query to prompt for the
number part).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

You might be right ... would it make a difference if the field were numeric
.... oops, nevermind, it has to have alpha characters, so it has to be an
alpha string!

Good catch, Doug!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top