Building Expressions - DON'T KNOW HOW

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok - so here is my delima - I have an access database and I am using the
query feature and need the query to pull out specific information. The
problem is that I don't know how to put in what I need it to pull out. I
need in my Rate column for the expression to pull number between 50 and 60 -
and in my Original Amount column I need it to bring numbers that are greater
than 599. So in short - i am looking for pull rates that are between 50 and
60 and with amounts greater than 600 only. HELP How do i do this?????
 
hi sandi,

In your query, right click in its title bar, and select "SQL View". Add the
following to the end of the query:

WHERE (((tablename.pullrate) Between 50 And 60) AND ((tablename.amount)>600));

OR In the query's design view:
add to the conditions for each column:
for the [pullrate] column:
Between 50 And 60
and for the [amount] column:
600
Click to expand...

hope this helps.
 
What you use the the Criteria row of the query
the criteria for the rate problem is
between 50 and 60
for the Amounts column
600
Click to expand...

Remeber Access is inclusing. Rates of 50 and 60 will be included in you
query results
 
I tried entering that in the query design view between 50 and 60 and in the
amount i entered >599. It wouldn't display any results, but when you go back
and look at the Table you can see that there number between those rates with
amounts higher than 600....any ideas?
--
Sandi Gardner


geebee said:
hi sandi,

In your query, right click in its title bar, and select "SQL View". Add the
following to the end of the query:

WHERE (((tablename.pullrate) Between 50 And 60) AND ((tablename.amount)>600));

OR In the query's design view:
add to the conditions for each column:
for the [pullrate] column:
Between 50 And 60
and for the [amount] column:
600
Click to expand...

hope this helps.

Sandi said:
Ok - so here is my delima - I have an access database and I am using the
query feature and need the query to pull out specific information. The
problem is that I don't know how to put in what I need it to pull out. I
need in my Rate column for the expression to pull number between 50 and 60 -
and in my Original Amount column I need it to bring numbers that are greater
than 599. So in short - i am looking for pull rates that are between 50 and
60 and with amounts greater than 600 only. HELP How do i do this?????
Click to expand...
Click to expand...
 
I tried that and it didn't work for me. It will pull information if i put in
"like "*50*" or like "*60*" not sure what the problem is but it's very
frustrating.
 
Ok - so what would I need to do. The rates are entered as 50.00 and the
amounts are as $612.99. How would I check this. As I said - I am oblivious
when it comes to Access
 
I must have had a brain freeze - i knew that :-) I will check on that and
see if that is the case.
 
Back
Top