A field on a query has a value in it I'd like to use to create tot

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

Guest

Cost: Proceeds: G/L St G/L LT
30,000 31,000 $1,000
25,100 24,095 ($905)
4,000 5,000 $500 $500

In the G/L St & G/L Lt field, I would like to pull out the cost/proceeds
values to create a field that I can run a cost or proceed total on. I have
done an IIf function that works in pulling out the values but in the report
footer when I try to sum the data, it doesn't work. FYI: The iif function is
this: Iif([g/l st]<>O,[cost],"").

Any ideas?


Please help!
 

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

Combining Fields in a Query into Two Fields 3
Using a Yes/No field to trigger a calculation in another field - J 3
optimize queries that refer to a calculated field in a source table 1
Multiple calculations on same field in Query, by range of values 5
Using criteria on a calculated field in a query 1
Can an update query return a calculated value to a select query? 2
create new field in query not working? 15
Using Switch to post a numberic value in a query 1

Back
Top