multiple items with a twist

  • Thread starter Thread starter Jonell
  • Start date Start date
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
 
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
 
Hate to disagree, Jeff, but shouldn't that be

Like "12345*"
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Just for TC 2
Query Parameter using multiple options 0
Access Dcount (multiple criteria) 3
Trying to get global value as entry on multiple tables 2
Headset microphone operation, and multiple microphone set-ups 1
Appointment schedule - with a twist 4
Strange Lookupbox 1
how to merge mult records into a single record 2

Back
Top