Query Question

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

Guest

I am looking for a percentage. I have a date issued field and a date
redemeeded field for passes we sell. I want to know the percentage of passes
being used for a month. What do I type inot the criteria field, or do I have
to do something else?
Thanks a million!
Melissa
 
Are you saying that if you sell 100 passes in February and 75 of these passes
were used in February that you want the query to display "75%" for February?
 
That is exactly what I'm looking for, can you help?
That would be great
Thanks again!
 
You'd have to tell us how you calculate this, and then we can help you do it
in Access. How do you do it now? What is your formula?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date search query 0
Increasing a price by % 2
Report-Chart Wizard-AVG instead of SUM 2
Design and layout for Order Analysis? 5
query total 2
Need help Sorting By Date Using a Formula 1
Progress bar based on percentage 3
Update one field from another field in same table 3

Back
Top