Calculation

[nbuwalda]

I am trying to get a calculation to show within a form. The calculation
shows and is correct within the query. Right now I have the query pulling
the information from the table and the form pulling the information from the
query. I have the following equation setup in the query: Used: [Beginning
of Month] - [End of Month]. Now how do I get the output from this to display
in my form?

 

[Todd Shillam]

Place an unbound textbox on your form; however, you must place it within the
detail section. Change the unbound textbox's control source to 'Used' (you
should see it in the field list window).

Best regards,


Todd

 

[Sprinks]

Ni, nbuwalda.

If you've created a calculated field named Used in your query, you can set a
control's ControlSource to it just like any other field. Place a textbox,
and set its ControlSource to Used, or drag and drop Used from the FieldList.
If Used isn't in your FieldList, check the form's RecordSource property. It
should be set to the name of your query.

Hope that helps.
Sprinks

 

[nbuwalda]

I did the below and instead of outputting the number it gave me the
following: #Name? What is this?

Place an unbound textbox on your form; however, you must place it within the
detail section. Change the unbound textbox's control source to 'Used' (you
should see it in the field list window).

Best regards,


Todd

I am trying to get a calculation to show within a form. The calculation
shows and is correct within the query. Right now I have the query pulling
the information from the table and the form pulling the information from
the
query. I have the following equation setup in the query: Used:
[Beginning
of Month] - [End of Month]. Now how do I get the output from this to
display
in my form?