pulling 3 criteria using 1 parameter?

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

I have a table that has every mlb baseball team since 1871

Ex. Milwaukee were the Braves then the Brewers, in the db Milwaukee has
TeamID of Mil, ML1, ML4

(There are several other teams that have multiple TeamID's too.)

Is there a way to create a table and then a query that would allow me to -

type Milwaukee into a parameter field for a query, and pull all the
records
that match Mil, ML1, ML4?

what is the best way to go about this?

TIA,
_Bigred




I'm protected by SpamBrave
http://www.spambrave.com/
 
Create a "franchise" table with values like:
TeamID Franchise
Mil Milwaukee
ML1 Milwaukee
ML4 Milwaukee

You would need at least one record in the table for each unique TeamID. Add
this table to your query.
 
thanks much Duane, I'll try that out and report back on the results.
_Bigred


Duane Hookom said:
Create a "franchise" table with values like:
TeamID Franchise
Mil Milwaukee
ML1 Milwaukee
ML4 Milwaukee

You would need at least one record in the table for each unique TeamID.
Add
this table to your query.
Click to expand...



I'm protected by SpamBrave
http://www.spambrave.com/
 
WORKED LIKE A CHARM Duane, thanks again for your help.

Works great,
_Bigred




Duane Hookom said:
Create a "franchise" table with values like:
TeamID Franchise
Mil Milwaukee
ML1 Milwaukee
ML4 Milwaukee

You would need at least one record in the table for each unique TeamID.
Add
this table to your query.
Click to expand...



I'm protected by SpamBrave
http://www.spambrave.com/
 
Back
Top