search for multiple criteria

[SteveBB]

Hi,

I'm having a little trouble creating a query that will allow me to search my table using multiple user defined criteria from a single field.

The database holds a list of email addresses and a respective email template that should be sent. Some of the templates are the same and so I need to be able to search for multiple user defined template ID's.

I've tried using the following:-

SELECT Templates.[Template ID], Templates.partner, Templates.[Customer Type], Templates.[Account Type], Templates.account_number, Templates.Title, Templates.[First name], Templates.[Last name], Templates.email_address
FROM Templates
WHERE (((Templates.[Template ID ])=[insert template ID])) OR (((Templates.[Template ID])=[insert template ID]));

This was created in access query design and I used the OR field to create this one. I also tried using the "OR" function within the main criteria line but in both scenarios I'm only asked once for a template ID .

I even tried adding the template ID field twice but got the same result.

I need to be able to enter multiple ID's in the query.

Any help greatly appreciated

 

[SteveBB]

Never Mind - I figured it out - I needed to define the 2 separate criteria by having different names so instead of using [Insert template ID] twice I added and 1 & 2 problem solved

Hi,

I'm having a little trouble creating a query that will allow me to search my table using multiple user defined criteria from a single field.

The database holds a list of email addresses and a respective email template that should be sent. Some of the templates are the same and so I need to be able to search for multiple user defined template ID's.

I've tried using the following:-

SELECT Templates.[Template ID], Templates.partner, Templates.[Customer Type], Templates.[Account Type], Templates.account_number, Templates.Title, Templates.[First name], Templates.[Last name], Templates.email_address
FROM Templates
WHERE (((Templates.[Template ID ])=[insert template ID])) OR (((Templates.[Template ID])=[insert template ID]));

This was created in access query design and I used the OR field to create this one. I also tried using the "OR" function within the main criteria line but in both scenarios I'm only asked once for a template ID .

I even tried adding the template ID field twice but got the same result.

I need to be able to enter multiple ID's in the query.

Any help greatly appreciated