Create A Search

I

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.
 
C

Charles L. Phillips

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


Charles L. Phillips
 
C

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

injanib via AccessMonster.com said:
NO, I am not sure what you mean.
Hello,
Have you tried creating a query for this request???

Charles L. Phillips
Fellas,
Click to expand...
[quoted text clipped - 22 lines]
what is my best solution. Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Top