Text Box become numerical (Maybe Easy)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box off of a parameter in a query. On the report the text box
says:
=[Enter Start Date] So the start date can show up on the report. However,
I have a computational element in the report using the number of days. I
need the text to be numerical so that I can subtract days from it. How can
this be done?

For example: I'll type "05/22/05". The parameter will collect this number
in the report. When I subtract 06/01/05 from 05/22/05 in a text box, I get
an "error". I need to know how to create a text box that will take it and
enter it as a date so it can be subtracted. Other dates work just fine.
 
dogpigfish said:
I have a text box off of a parameter in a query. On the report the text box
says:
=[Enter Start Date] So the start date can show up on the report. However,
I have a computational element in the report using the number of days. I
need the text to be numerical so that I can subtract days from it. How can
this be done?

For example: I'll type "05/22/05". The parameter will collect this number
in the report. When I subtract 06/01/05 from 05/22/05 in a text box, I get
an "error". I need to know how to create a text box that will take it and
enter it as a date so it can be subtracted. Other dates work just fine.
Click to expand...


Most likely, the text box is named the same as a field in
the query. If so, change the text box's name to something
else.

If that's not the problem, post back with the names of the
relevant fields, the names of the text boxes and their
ControlSource property.
 
Back
Top