INDIVIDUAL INQUIRES

  • Thread starter Thread starter SIRSTEVE
  • Start date Start date
S

SIRSTEVE

I created a database so that I can keep track of contributions given to our
organization. And from time to time, I would like to do an inquiry on one
person instead of running a report for everyone. How can I perform a simple
Query? Listed below are the fileds I've created.

DATE:
OFFERING TYPE:
ENVELOPE:
LAST NAME:
FIRST NAME:
TITLE:
AMOUNT:

If there is anyone who can help me, please email me. Thanks for your
assistance.
Steve
 
Create a querry and set a criteria with the persons account number under the
account field.
 
I created a database so that I can keep track of contributions given to our
organization. And from time to time, I would like to do an inquiry on one
person instead of running a report for everyone. How can I perform a simple
Query? Listed below are the fileds I've created.

DATE:
OFFERING TYPE:
ENVELOPE:
LAST NAME:
FIRST NAME:
TITLE:
AMOUNT:
Click to expand...

Create a new Query using the New command button on the Query tab of the
database window.

Add your table.

Select whichever fields you want to see.

Put a criterion under the field that you want to search - i.e. to find all
contributions from people named Steve, put

"Steve"

on the criteria line under First Name. Better, put

[Enter first name:]

under FIRST NAME, and

[Enter last name:]

under LAST NAME.

Base your Report on this query.
If there is anyone who can help me, please email me. Thanks for your
assistance.
Click to expand...

That would a) be impossible since you did not post a working email address and
b) would go against the customs of this newsgroup: ask here, come back here
for your answer. We're all volunteers here; I'm a self employed consultant and
must reserve private email support to paying customers.

John W. Vinson [MVP]
 
Back
Top