Idebtify Dates Within A Date Range

[Guest]

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

 

[Guest]

Between [Enter start date] And [Enter end date]

 

[kingston via AccessMonster.com]

Let's say you have a table with a field [MyDate]. Create a query and add the
field along with the other fields you want. As the criteria for [MyDate],
enter "Between [Start Date] and [End Date]" (without the quotation marks).
The query (and the report that's based on it) will prompt the user for [Start
Date] and [End Date] and return all records where [MyDate] is between those
dates inclusive. If you want to prevent bad input (i.e. data that isn't an
actual date), use the function IsDate() in an IIF() statement.

 

[Guest]

Between [Enter StartDate] And [Enter EndDate]

 

[Guest]

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Let's say you have a table with a field [MyDate]. Create a query and add the
field along with the other fields you want. As the criteria for [MyDate],
enter "Between [Start Date] and [End Date]" (without the quotation marks).
The query (and the report that's based on it) will prompt the user for [Start
Date] and [End Date] and return all records where [MyDate] is between those
dates inclusive. If you want to prevent bad input (i.e. data that isn't an
actual date), use the function IsDate() in an IIF() statement.

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

 

[Guest]

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Between [Enter StartDate] And [Enter EndDate]

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

 

[Guest]

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Between [Enter start date] And [Enter end date]

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

 

[kingston via AccessMonster.com]

Let's say you filter the records with this query first. Then, create another
query (a totals query) where you group by the date and display the average of
the value you require. You can also use a DAvg() function but try a second
query first.

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Let's say you have a table with a field [MyDate]. Create a query and add the
field along with the other fields you want. As the criteria for [MyDate],

[quoted text clipped - 8 lines]

 

[Guest]

Create a Totals query.
Group by the date and Average whatever field you are trying to get an
average on.

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Between [Enter StartDate] And [Enter EndDate]

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?

 

[Guest]

That worked great, Thank you for all your help.

Let's say you filter the records with this query first. Then, create another
query (a totals query) where you group by the date and display the average of
the value you require. You can also use a DAvg() function but try a second
query first.

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Let's say you have a table with a field [MyDate]. Create a query and add the
field along with the other fields you want. As the criteria for [MyDate],

[quoted text clipped - 8 lines]

the prompted date range. How can I get the individual data for the dates in
the range?

 

[Guest]

That worked great, Thank you for all your help.

Create a Totals query.
Group by the date and Average whatever field you are trying to get an
average on.

Between and And will give me tha date range but once I have the range I need
to show daily averages. I can't figure out how to get an average for the days
in the middle of the date range. Say I capture date range of 8-1-06 through
8-5-06. I write it to a temp table. Ho wo I get the chart on a report to show
the averages for each of the 5 days individually?

Between [Enter StartDate] And [Enter EndDate]

:

I am trying to create a Report based on a Query that prompts for a date
range. I need to display a chart of the daily averages of the dates with in
the prompted date range. How can I get the individual data for the dates in
the range?