control source in access not adding up

[t5amec]

I have a day rate field[txtDayRate] and a hourly rate field[txtHourRate] and i want to add these two fields together in a query. But when I enter =[txtDayRate]+[txtHourRate] in the control source of the total rate txt box i get nothing but blank.

What's going on?!



Make Sense? I hope so (-:

 

[chris153]

Hi,

Through the expression builder try adding the values in the field list rather than the text boxes in the report.

 

[randysmid]

Hi,
You said that you want to add these two values together in a query. This is totally possible. Please see my FAQ on how to add a custom field to a query: [faq701-3273]

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association