If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a variable to a report
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 |
#2
|
|||
|
|||
Adding a variable to a report
"CD Tom" wrote in message ... 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. 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 |
Thread Tools | |
Display Modes | |
|
|