Macro Question? Querying a table to create a new report (1 Viewer)

smelff · Apr 14, 2010

I have a table organized by account number with fields for employee IDs, start dates, end dates, and percentages of time dedicated to that account, for up to 15 employees. I need to create a report that returns the all of account numbers, associated start/end dates and dedication times, for a given employee.

Best way to do this? I've also posted to the macros board.

HiTechCoach · Apr 15, 2010

smelff said:
I have a table organized by account number with fields for employee IDs, start dates, end dates, and percentages of time dedicated to that account, for up to 15 employees. I need to create a report that returns the all of account numbers, associated start/end dates and dedication times, for a given employee.

Best way to do this? I've also posted to the macros board.

It sounds like you have a single record with fields for up to 15 employees?

If that is true, then there is a serious issue with your table design.

Each employee should be a separate record.

If the design is correct, then this will be a very easy query.

NOTE:I would urge you NOT to double post!

Macro Question? Querying a table to create a new report (1 Viewer)

smelff

New member

HiTechCoach

Well-known member

Similar threads

Users who are viewing this thread