Re: IIF parameter

There is a field that has the company name, we used [ECCN]. The field
actually spells out the Comapny Name (not Numeric)
There are three companies, Company 3 uses the same accounts as Company 1.
As you can see Company 2 is the exemption. But we want to use "ALL" as an
additional option. There are other accounts we need to exclude even if we
select "ALL".
Many Thanks!
"Conan Kelly" <CTBarbarin@xxxxxxx> wrote in message
news:IuVog.278013$Fs1.106487@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Angel,

I think I know of a way, but it is somewhat complicated and time
consuming. I would be glad to help, if no one else can offer advice.

I need to know a couple of things first:

Is there a field in the table that signifies which Company a record
belongs to or is it purely determined by the account number?

How many different Companies do we have here? Just the 2 mentioned her,
or is ther more that you will need to query on as well?

Hope I can be of some help,

Conan Kelly

"Angel_G" <nomail@xxxxxxxxx> wrote in message
news:uGUO2e6mGHA.924@xxxxxxxxxxxxxxxxxxxxxxx
Hi! I am trying to write a query that based on a Form's (Salesfrm)
Selection Combo Box(CompanyCombo) the query will provide data.
I am trying to use the IIF statement with out luck (not sure if there is
a better way to do this) .
I need the query to lookup records IF the Selection value = "Company1"
then Like "*40000*" Or Like "*40001*" Or Like "*40002*" Or Like "*40003*"
Or Like "*40060*"
But if selection value = "Company2" then Like "*40030*" Or Like "*40031*"
But if selection value = "All Companies" then Like "*40000*" Or Like
"*40001*" Or Like "*40002*" Or Like "*40003*" Or Like "*40060*" or Like
"*40030*" Or Like "*40031*" (note: I can not use a wild card here because
I do not want to inclue all accounts)
Any ideas are more than welcomed.
Thank you!





.

Relevant Pages