Using the same field twice with a diff qry on each

[coryras]

I am trying to use the field balance twice in a report. Each balance is for a different date. I made two separate queries for the two balances and used one query within another. When I try to use the fields in the report it says that the field balance may be referring to more than one table. I am not sure how to solve this error. Any advise would be appriciated. Thanks

 

[CosmoKramer]

Are the two balance fields named the same in each query? If so you will have to change one or both of them. Create an expression field:

txtBalance1: balance

in one query

txtBalance2: balance

in the other.....

 

[randysmid]

Hi,
Within the query, you can create a custom field for the 2nd balance. I wrote an FAQ on how to create custom query fields: faq701-3273
Although my FAQ refers to functions, using functions is not necessary in your case.

HTH,
Randy Smith
California Teachers Association

 

[coryras]

Hi CosmoKramer,
The information you gave me did the trick. Thankyou very much for your time and help.
coryras