Simple Date Range Help

[Anthony Lisanti]

I have a project for work that need data broken up as follows


Billed Sales Affiliate International
Billed Sales Affiliate Domestic

We have special codes for each International and Affiliate, so sorting
that will be no problem. I need to know a way to pull the data by
just inputting a weekly date range and displaying the total for the
week.

My supervisor suggested going through the entire backup of excel files
for the weeks in the month pulling out everything but what I need then
making a pivot table. This seems like a huge process. I know
there can be a date range that I can do in Access. I have the entire
year off all the data I need thus far in 1 table, and a brief Date
range query. Any idea how to make this quick, with no VBA
programming?


I am a beginner, and a finance guy just trying to make my life easier.

Tony

 

[Arvin Meyer [MVP]]

You can do it with a form, or just a plain criteria in the query:

For plain criteria:

Between [Enter a Start Date] And [Enter an End Date]

there will be a prompt for both start and end date. For a form, create 2
text boxes: txtStartDate and txtEndDate. Then use the following criteria:

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

 

[john smith]

I have a project for work that need data broken up as follows


Billed Sales Affiliate International
Billed Sales Affiliate Domestic

We have special codes for each International and Affiliate, so sorting
that will be no problem. I need to know a way to pull the data by
just inputting a weekly date range and displaying the total for the
week.

My supervisor suggested going through the entire backup of excel files
for the weeks in the month pulling out everything but what I need then
making a pivot table. This seems like a huge process. I know
there can be a date range that I can do in Access. I have the entire
year off all the data I need thus far in 1 table, and a brief Date
range query. Any idea how to make this quick, with no VBA
programming?


I am a beginner, and a finance guy just trying to make my life easier.

Tony