Passing parameter between 2 reports

  • Thread starter Thread starter Stephm
  • Start date Start date
S

Stephm

Hi. PC Datasheet showed me how to use an input form to
pass the parameter from one report to the next (using one
query). Very cool!

Now I want to share information between 2 reports, put
I'm not using an input form. Rather I'm using [Reference
date for Renewals: (MM/DD/YY)] to get the user's date.
I'm also using this same information in a DateDiff
calculation:

Expr1: DateDiff("m",Max(MembershipType.DateOfLastRenewal),
[Reference date for Renewals: (MM/DD/YY)],True)

(I did try to use input form DateParam with unbound field
FindDate, but I couldn't make it work with DateDiff).

So, the question is can I still pass the "parameter" from
one report to the next? As is, the user has to re-enter
the "reference date" on the 2nd report, which is tedious
and would no doubt lead to inconsistencies. Thanks for
your help, Steph
 
Use a reference to a control on a form. What happened when you tried to use
it in DateaDiff()?
 
Thanks for the reply- I just had my syntax messed up.
Annie
-----Original Message-----
Use a reference to a control on a form. What happened when you tried to use
it in DateaDiff()?

--
Duane Hookom
MS Access MVP


Hi. PC Datasheet showed me how to use an input form to
pass the parameter from one report to the next (using one
query). Very cool!

Now I want to share information between 2 reports, put
I'm not using an input form. Rather I'm using [Reference
date for Renewals: (MM/DD/YY)] to get the user's date.
I'm also using this same information in a DateDiff
calculation:

Expr1: DateDiff("m",Max (MembershipType.DateOfLastRenewal),
[Reference date for Renewals: (MM/DD/YY)],True)

(I did try to use input form DateParam with unbound field
FindDate, but I couldn't make it work with DateDiff).

So, the question is can I still pass the "parameter" from
one report to the next? As is, the user has to re- enter
the "reference date" on the 2nd report, which is tedious
and would no doubt lead to inconsistencies. Thanks for
your help, Steph
Click to expand...


.
Click to expand...
 
Back
Top