substraction

[sharon]

I am trying to create a querry were I substract one
figure from another in two different table columns for
each client.

for example

row 1 row2
1281 2012
1002 1645

So I want a query that would substract row 2 from row 1
and give me an answer for each client.(2012-1281) would
be one answer and then (1645-1002)would be the next ans
so on. By the way each of the fields are times in a 24
hour clock

thanks

 

[Jeff Boyce]

Sharon

Start a new query in design mode. Add the table that includes the two
columns. Create an "output" field, named as you wish, and show the
subtraction of the two fields -- something like:

YourOutputFieldName: [YourSecondColumnName] - [YourFirstColumnName]

By the way, I am somewhat confused by your design. Your post said you
wanted to find the difference between "two different table columns", but
your example had two columns named "row1" and "row2". Rows, ... or columns?

Good luck

Jeff Boyce
<Access MVP>