Creating a Date Range in a Query & Report

[ricseb]

I've been requested to create a report with a date range. I've created a
query from two tables that have a "Start Date" & a "Completion Date" record.
For example, what expression/operator/criteria would one suggest to
accomplish creating a "Date Range" in a report of the number of a product
that was installed over a period of time using these two records?

Thanks.

R. Sebastian

 

[RBear3]

So you want to see all the records where the item was completed between two
dates?

Just put criteria under the completion date of...

Between [Enter Start Date] and [Enter End Date]

 

[ricseb]

thanks a lot. I'll try that & let U know the results.

ricseb

So you want to see all the records where the item was completed between two
dates?

Just put criteria under the completion date of...

Between [Enter Start Date] and [Enter End Date]


--
Hope that helps!

RBear3
..

I've been requested to create a report with a date range. I've created a
query from two tables that have a "Start Date" & a "Completion Date"
record.
For example, what expression/operator/criteria would one suggest to
accomplish creating a "Date Range" in a report of the number of a product
that was installed over a period of time using these two records?

Thanks.

R. Sebastian

 

[ricseb]

This creates a Parameter Query, which is not what I'm trying to do. I need
the report to show a date range based on the query which is getting info from
two records: [START DATE] and [COMP DATE]. Any suggestions without using a
parameter query?

Thanks.

ricseb

So you want to see all the records where the item was completed between two
dates?

Just put criteria under the completion date of...

Between [Enter Start Date] and [Enter End Date]


--
Hope that helps!

RBear3
..

I've been requested to create a report with a date range. I've created a
query from two tables that have a "Start Date" & a "Completion Date"
record.
For example, what expression/operator/criteria would one suggest to
accomplish creating a "Date Range" in a report of the number of a product
that was installed over a period of time using these two records?

Thanks.

R. Sebastian

 

[Duane Hookom]

Your question is quite confusing. Can you share table and significant field
names and possibly some data? Then explain what you want displayed in your
report.

--
Duane Hookom
Microsoft Access MVP

This creates a Parameter Query, which is not what I'm trying to do. I need
the report to show a date range based on the query which is getting info from
two records: [START DATE] and [COMP DATE]. Any suggestions without using a
parameter query?

Thanks.

ricseb

So you want to see all the records where the item was completed between two
dates?

Just put criteria under the completion date of...

Between [Enter Start Date] and [Enter End Date]


--
Hope that helps!

RBear3
..

I've been requested to create a report with a date range. I've created a
query from two tables that have a "Start Date" & a "Completion Date"
record.
For example, what expression/operator/criteria would one suggest to
accomplish creating a "Date Range" in a report of the number of a product
that was installed over a period of time using these two records?

Thanks.

R. Sebastian