By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Criteria for a calculated field

P: 1
Hi

I have had difficulty with this for some time.
I have a database which has the fields COST, GST and RRP.

The issue is that RRP is calculated using the other two fields (COST and GST)

I am required to find everything BETWEEN $15 and $20 for RRP

I attempted to type
Between "$15.00" And "$20.00 in the criteria field for RRP

When I attempted to run, I am asked parametre COST and GST.

How can I display records for RRP for only between 15 and 20 without being prompted to put something in for COST and GST.

I have been working on this for over 4 hours now and would just like some tutorial on how, please.
May 9 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi

I have had difficulty with this for some time.
I have a database which has the fields COST, GST and RRP.

The issue is that RRP is calculated using the other two fields (COST and GST)

I am required to find everything BETWEEN $15 and $20 for RRP

I attempted to type
Between "$15.00" And "$20.00 in the criteria field for RRP

When I attempted to run, I am asked parametre COST and GST.

How can I display records for RRP for only between 15 and 20 without being prompted to put something in for COST and GST.

I have been working on this for over 4 hours now and would just like some tutorial on how, please.
can you paste in the SQL for your query?
May 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.