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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on previewing reports 1
VBA: How can I use a string variable as autofilter criteria? 4
Creating a report that has criteria 1
Specifying conditional Criteria in a Query or Report 6
How to create a bubble chart with more than 2 variables 0
Using WHERE clause when launching Reports from Code 4
I need a Form button to open and pass two variable values to a re 2
Date parameters for report 2

Back
Top