Access Newbie - Query to Pull Records by Predefined Sales Cycle 1

[bhharrison]

In Access 2003, I am attempting to pull records based on the Sales Cycle in which they were received. I have one table setup for the Sales Cycles:
CycleID, Sales Cycle, Cycle Begin Date, Cycle End Date
Previously, I had the query setup to request the user input the begin and end date for the Sales Cycle, but would like to be able to choose the Sales Cycle from the pre-defined list. Someone told me that I would need to do this through a form, but I'm not really sure how to accomplish this. As I'm new to SQL and to Access, any assistance would be greatly appreciated. Even pointing me to recommended training would be great!

 

[SkipVought]

Hi,

I suppose that you would create a table with...
[tt]
Sales_Cycle
From_Date
Thru_Date
[/tt]


Skip,

_[red][/red]

 

[bhharrison]

Thanks, Skip. Actually, I have already created that table. Also, I've got the Transactions table that has the field Received Order Date . Currently, the query has the following criteria setup in the Received Order Date:
Between [Enter Begin Date of Sales Cycle] AND [Enter End Date of Sales Cycle]

Instead of having the user enter this information though, I would like to be able to simply have the user select from a drop-down box showing the list of pre-defined Sales Cycles.

 

[SkipVought]

something like...

Received Order Date:
Between (Select BeginDate from Cycle where SalesCycle=me.[SelectedSalesCycle]) AND (Select EndDate from Cycle where SalesCycle=me.[SelectedSalesCycle])

Skip,

_[red][/red]

 

[bhharrison]

Thank you!! I'll try this out!

Blake Harrison
Quality Assurance & Sales Reporting

http://www.integralchoice.com