Create A Search

[injanib]

Fellas,

My form contains fields that are combo boxes and plain text boxes. For
example some of the fields are as follows.

"Name" (Text box)
"Company" (Combobox) includes a list of companies.
"Invoice" (Combobox) includes (Paid, Not Paid)
"RSA Type" (Combobox) includes (Temp, RSA, NCN)

I enter data in these fields and save them in a database making the proper
selections.

What I would like to be able to do is search the database and get a report of
only the records that meat on or more of the crieterias. For example: I want
to get a report of all the records for which the "Not Paid" selection has
been made from the "Invoice" combobox. Or type a name and get all the record
for that particular name.
I also would like to be able to combine these crieterias for a more specific
search.

what is my best solution. Thanks in advance.

 

[ajetrumpet]

injanib,

take a look at this attachment, the "search invoices" button on the switchboard takes you to a form that does exactly what you want. Take a look at the code of the underlying query....

 

[Charles L. Phillips]

Hello,
Have you tried creating a query for this request???


Charles L. Phillips

 

[injanib via AccessMonster.com]

NO, I am not sure what you mean.

Hello,
Have you tried creating a query for this request???

Charles L. Phillips

Fellas,

[quoted text clipped - 22 lines]

what is my best solution. Thanks in advance.

 

[ajetrumpet]

Injanib,

Did that DB help at all?
Doesn't that do the same thing that you're trying to do right now?
and did you write a query for this form already or not?

 

[Charles L. Phillips]

Hello,
It's like asking the database (db) a question.
Example(s):
Company: Invoice ("Paid" Or "Not Paid"): RSA Type (Temp)
Company: Invoice ("Paid" Or "Not Paid"): RSA Type (RSA)
Company: Invoice ("Paid" Or "Not Paid"): RSA Type (NCN)

You are asking the db a question, based on the infomation provided in the
fields


Charles L. Phillips

NO, I am not sure what you mean.

Hello,
Have you tried creating a query for this request???

Charles L. Phillips

Fellas,

[quoted text clipped - 22 lines]

what is my best solution. Thanks in advance.