Referencing other calculated fields

[MonkeyChico]

I've been googling this for an hour to no avail. I am creating a simple query and have a field that is a calculation of another field (i.e. DWF: IIf([DWF?]=True,"DWF "," "). How would I reference this calculated field so I can use it in another formula i.e. Lines: [DWF] & [Auto]. When I run the query I get Enter Parameter Value for DWF.

How do I reference this calculated field?

Thanks!

 

[PNGBill]

Your first use of DWF: IIf([DWF?]=True,"DWF "," ").. should there by a ? in this ??

If DWF is true, then DWF else " " (space)

When you next use DWF you will either have DWF or a space.

can you change the names.

First DWFFirst: IIF([DWF]......)

Second Lines: [DWF]&[Auto]

If you want the result of the first to be in the 2nd then include the IIF in the 2nd, not the result.

Lines: IIF([DWF]....)&[Auto]

 

[MonkeyChico]

Thanks for you help. I figured out my issue - the fields I was referencing in my query were not checked "Show:". I didn't know that you could not reference a field that wasn't displayed in the actual query.

Thanks,
Joe