Hi,
I'm trying to prompt my user to enter ID's for a company. Some companies have 1 ID, some have several and we have no way of distinguishing between them.
I want my user to be prompted like such:
They enter an ID and hit enter. What can I do to get multiple values?
My SQL statement looks like this:
SELECT dbo_Exchanges.Province, dbo_Exchanges.[Name edited], mad_MadEntity.MadName, dbo_Exchanges.ExchangeID, mad_MadEntity.MadNumber INTO ExchangeIDQueryResults1
FROM dbo_Exchanges INNER JOIN mad_MadEntity ON dbo_Exchanges.[ILEC MAD] = mad_MadEntity.MadNumber
WHERE (((dbo_Exchanges.ExchangeID)=[Enter Exchange ID]));
Thanks for your help!