Creating a Date Range in a Query & Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
thanks a lot. I'll try that & let U know the results.

ricseb

RBear3 said:
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
..

ricseb said:
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
Click to expand...
Click to expand...
 
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

RBear3 said:
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
..

ricseb said:
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
Click to expand...
Click to expand...
 
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


ricseb said:
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

RBear3 said:
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
..

ricseb said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top