Quiery on formatted report based on multiple criteria

G

Grant

I am trying to create a report based on a database created with a realtime
database recording engine.

I would like to know (If it is possible - which I believe it is) how to
quiery the database file to do a calculation on two values in the first
column, that meet specified criteria in another column, dependening on a
matching value in another column.

If this does not make sense here is an example:

06:00.123 Yes Blue 01273
06:01.234 No Green 01243
06:01.345 Yes Red 01273

I would like to subtract the "time stamp" if Value1=Yes and Value2=Blue from
a "time stamp" where Value1=Yes and Value2=Red, Provided that Value3=01273
for both.

Any ideas?

Thanks
 

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

Standard Deviation and Averages based on criteria 2
if then multiple sheets and values 2
Report based on query shows no data 1
PROBLEM - Report based on query that has criteria based on listbox 3
Report based on criteria form 5
Calculated values insertion into report based on a criteria 1
dlookup based on two criteria 1
Help counting multiple checkboxes in a form to make a total in a report 3

Top