Number of Days between in Parameter Query

[ChuckW]

Hi,

I have an access application with two text boxes: Start
Date and End Date along with a command button that is a
report. In my query that runs the report I have the
following in my Criteria:

Between [Forms]![SelectSalesALL]![txtStartDate] And
[Forms]![SelectSalesALL]![txtEndDate]

I now need to calculate the difference between the two
dates that the user enters into the text boxes. It can
be in another query that reads the first query. Can
someone help?

Thanks,

Chuck

 

[fredg]

Hi,

I have an access application with two text boxes: Start
Date and End Date along with a command button that is a
report. In my query that runs the report I have the
following in my Criteria:

Between [Forms]![SelectSalesALL]![txtStartDate] And
[Forms]![SelectSalesALL]![txtEndDate]

I now need to calculate the difference between the two
dates that the user enters into the text boxes. It can
be in another query that reads the first query. Can
someone help?

Thanks,

Chuck

Why not just do it once in the report?
In an unbound control's Control Source:
=DateDiff("d",([Forms]![SelectSalesALL]![txtStartDate]),([Forms]![SelectSalesALL]![txtEndDate]))

The form must be open when the report is run.

 

[John Spencer (MVP)]

You can do it in the query itself as a calculated column

Field: DaysApart: DateDiff("d",[Forms]![SelectSalesALL]![txtStartDate],[Forms]![SelectSalesALL]![txtEndDate])

Or you can use the above expression as the Control source on control on your report.

=DateDiff("d",[Forms]![SelectSalesALL]![txtStartDate],[Forms]![SelectSalesALL]![txtEndDate])