Emily Crawford
Last Activity: Sep 14 '10, 08:04 PM
Joined: Sep 14 '10
Location:
-
Emily Crawford replied to How do I get my query to pull data based on two different sets of date parameters?in AccessOkay, thank you. I'll try. -
Emily Crawford replied to How do I get my query to pull data based on two different sets of date parameters?in AccessSELECT [PracticeQuery2 FOR USE IN ENROLLMENT QUERY].EmployeeLastNa me, [PracticeQuery2 FOR USE IN ENROLLMENT QUERY].EmployeeFirstN ame, [PracticeQuery2 FOR USE IN ENROLLMENT QUERY].RequestDate, [PracticeQuery2 FOR USE IN ENROLLMENT QUERY].EmployeeNum, [PracticeQuery2 FOR USE IN ENROLLMENT QUERY].TrainingReques ts, Enrollment2.Emp loyeeNum, Enrollment2.Tra iningTopicTaken , Enrollment2.Dat eTaken
FROM [PracticeQuery2 FOR USE IN ENROLLMENT QUERY] LEFT...Leave a comment:
-
Emily Crawford started a topic How do I get my query to pull data based on two different sets of date parameters?in AccessHow do I get my query to pull data based on two different sets of date parameters?
I have a query that has two date fields. One date field is from the Request Table and it is called RequestDate - the date the employee requested training. The second date field is called ClassTaken from the Enrollment Table - and it is the day the employee took the training they requested. I am trying to create a report that asks the user to input one set of dates for the RequestDate field and a different set of dates for the ClassTaken date fields...
No activity results to display
Leave a comment: