Create A Search

  • Thread starter Thread starter injanib
  • Start date Start date
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.
 
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....
 

Attachments

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


Charles L. Phillips
 
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?
 
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...
 
Back
Top