Query for Name/Address/And a single donation of $250 or more

[kpsony]

I work for a non profit and I need to run query to find out who in our DB has given a donation of $250 or more.

We have 2 Tables on named "The TTP DB" and "tblegifts"

They are connected through a column named "donor ID"

These are the fields I need to have FIRST NAME/LAST NAME/ADDRESS 2/PRIMARY CITY/PRIMARY STATE/PRIMARY ZIP/DATE OF GIFT/DONATION AMOUNT

Can anyone help?

Thanks,

B

 

[hneal98]

We need to know which fields go with which tables.

 

[HitechUser]

kpsony,

Use the query design. Create a link between them. Then drap the fields you need. Specify your selection criterea.

This link should help (with screen prints)

http://its.augustana.edu/documentation/access97/accessqueries.pdf

Good Luck...

 

[kpsony]

The DonorID/Gift Date/Gift Amount/ are in the 'tblegifts'

FIRST/LAST/ADDRES/CITY/STATE/ZIP are in the 'TTP Database"

Thanks

 

[GingerR]

Try HitechUser's idea. Try building a query first then let us know how far you get and if you still need help.

g

 

[kpsony]

I got the query done and in the criteria part of the Gift AMOUNT field I put <$250.00 and its giving me an error of "Data type mismatch in the criteria"..

 

[HitechUser]

kpsony,

I believe you need to remove the $ (dollar sign).

That should do the trick.

Good Luck...

 

[kpsony]

I wish it were that easy, still the same error.

<"250.00"

 

[HitechUser]

kpsony,

Remove the " (Quotes) this makes the value a Character string.


That should do the trick..

 

[kpsony]

It automatically puts the quotes, and what is a Character string? :-D

 

[HitechUser]

kpsony

A character string is "a string of characters" example

ABC123
John Smith
Boston
1/2 egges
$500.00

These are all character strings (typicaly text).

If the donation amount is stored in a numeric field you would reference it by its value (i.e. 250.00). Putting quotes around anything tells Access that this is to be treated like a string of characters. That being said...

This statement is true 250 = 250.00 (decimal assummed
This is not true "$250.00" = 250.00

Now you know what "Data type mismatch" is.

Consult the help text on how you need to enter a numeric value

I hope this helps..

Good Luck...

 

[GingerR]

Sounds like your field DonationAmount is text? Look in the design of the table, and check it there. It should be a number. My experience is that when I put in criteria and Access puts quotes around it, the field type is text.

g

 

[HitechUser]

kp

Here another link on creating queries. It has a screen print using values > (greater than) or < (less than).

http://www.meredith.edu/techserv/helpdocs/access_97-2000_queries_1.htm

As I stated earlier. Very if the field is text or numeric. Then enter the value needed.

Good Luck...