Adding a variable to a report

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

Guest

I use a criteria statement to select between dates from a query. I don't use the prompt in the query because of other selections that are part of the criteria. I have public variables set up for vbdate and vedate. I want these dates to appear on the report as a from to. I've tried using the standard =([vbdate]) but I only get the #error in the field. Can someone tell me what I'm doing wrong. Thanks for any help.

Tom
 
CD Tom said:
I use a criteria statement to select between dates from a query. I don't
Click to expand...
use the prompt in the query because of other selections that are part of the
criteria. I have public variables set up for vbdate and vedate. I want
these dates to appear on the report as a from to. I've tried using the
standard =([vbdate]) but I only get the #error in the field. Can someone
tell me what I'm doing wrong. Thanks for any help.This is covered in help.
You have to tell it where the information comes from

Usually it will be something like Forms!MyFormName!MyDateFieldName

= "From " & Forms!MyFormName!MyStartDateFieldName & " and " &
Forms!MyFormName!MyEndDateFieldName
 
Back
Top