expression built in LAYOUT View in form but not showing up in repo

B

Beth McLaren

I made a form with some expressions, i.e. =[Close date]-[Certificate Date]
that will give me a number of days between. When I make a report and add
this field within the report the values do not show up. I see them in the
form and in the table but nothing in the report. What am I doing wrong???
 
J

John W. Vinson

I made a form with some expressions, i.e. =[Close date]-[Certificate Date]
that will give me a number of days between. When I make a report and add
this field within the report the values do not show up. I see them in the
form and in the table but nothing in the report. What am I doing wrong???

Just use the same expression in the control source of a textbox on the report.
A calculated field on a Form isn't stored anywhere.
 

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

Top