Query Criteria, More OR

[ombadboy]

Am having a slight problem here. Am trying to use 3 exact values as Criteria in a query, but it seems it not working, only 2 appear (the 1st two). I've attached a screenshot of how my query design looks like.

[URL=http://img195.imageshack.us/i/query.png/][/URL]

 

[boblarson]

Am having a slight problem here. Am trying to use 3 exact values as Criteria in a query, but it seems it not working, only 2 appear (the 1st two). I've attached a screenshot of how my query design looks like.

Can't see your query design because ImageShack is blocked at work. Perhaps you could upload a copy here?

Or, just post the SQL from the query.

 

[ombadboy]

Here's the SQL, Ill try attach an image in the next post

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name)="Payment Request") AND ((MSysObjects.Type)=-32764)) OR (((MSysObjects.Name)="Offer")) OR (((MSysObjects.Name)="Extra Items"))
ORDER BY MSysObjects.Name;

thanks alot

 

[ombadboy]

here's the attachment

 

[boblarson]

I don't get why you are trying to get this out of the system table? Can you elaborate? It doesn't make sense as you are pulling the name for something that you already have the name in the Where Clause.

 

[ombadboy]

Am actually trying to make a drop-down box in a form, where it will 'select' the forms with those 3 names. The macro used after-update uses that to open the form.

And on that note.. I just had an enlightment, and have a small idea that all this is unnecessary, but it would be easier to use pre-existing values in the drop-down box, and use a macro to launch based on the value.

 

[boblarson]

Am actually trying to make a drop-down box in a form, where it will 'select' the forms with those 3 names. The macro used after-update uses that to open the form.

And on that note.. I just had an enlightment, and have a small idea that all this is unnecessary, but it would be easier to use pre-existing values in the drop-down box, and use a macro to launch based on the value.

I don't know if this will help, but I use something like:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32768) AND ((Left([Name],3))="frm"));


Where I only bring into the list the forms that start with frm.

 

[ombadboy]

I've completely re-worked it. Thanks alot.

What i've done ive got a pre-existing list of values for the drop-box, and then a macro with conditions ( if [field]="offer" then openform offers ), etc.. and works like a charm.

thanks again tho for the help