Hey I was just reading through and curious, would you do the following program loop in VB? I don't know much about access or SQL so I don't know what the capabilities are, but from what I have seen, this would be a programming function. If so, is this something that is coded right into one part of Access? Thanks...
luvy (Visitor) Nov 9, 2001
I have a personnel database in Access 97. Employees enter begin and end dates for leave. How would pull the information from the form for all of the dates in between, with the correct information for the particular employee associated with it into the tables. I need to be able to query all of the leave dates for reports! I could use very specific instructions. I thank you for the time and knowledge!
PaulF (TechnicalUser) Nov 9, 2001
Probably one of the "safest" ways to do it is to create a new table that contained two fields, one for the Employee's Primary Key and a Date Field. Then when the employee enters the start and the end dates and saves the record, you'd open this new table, set up a loop from the Start Date to the End Date and add a new record for each one. Then you'd be able to ensure that you'd capture all of the dates for any report or query that you do.
PaulF
luvy (Visitor) Nov 9, 2001
I have a personnel database in Access 97. Employees enter begin and end dates for leave. How would pull the information from the form for all of the dates in between, with the correct information for the particular employee associated with it into the tables. I need to be able to query all of the leave dates for reports! I could use very specific instructions. I thank you for the time and knowledge!
PaulF (TechnicalUser) Nov 9, 2001
Probably one of the "safest" ways to do it is to create a new table that contained two fields, one for the Employee's Primary Key and a Date Field. Then when the employee enters the start and the end dates and saves the record, you'd open this new table, set up a loop from the Start Date to the End Date and add a new record for each one. Then you'd be able to ensure that you'd capture all of the dates for any report or query that you do.
PaulF
