Problem creating query

  • Thread starter Thread starter binxxy
  • Start date Start date
B

binxxy

I am having a problem creating a query to bring up only specific
information from a table. I need to arrange this query by dollar
amounts between $50.00 and $100.00. I have tried to set the criteria
but come up with dollars outside the range that I have specified. Am I
setting the criteria incorrectly? Please help :confused:
 
Thanks for the advice. I figured out the issue. The original creator o
the database set up the fields incorrectly. Instead of them bein
currency, they were general text which was why when I would run th
query it gave me nothing. So I corrected them and now my boss is happy
I appreciate the help though.:
 
Back
Top