I've got a problem in my access db where I import a list of employee bank deductions and need to output to another format.
I need to go from multiple lines per employee to one line per employee.
In the attached sample, there are employees with varing number of deductions. The final output can only show the first 3 deductions.
I've attached a small example of what I need it to do, either with queries or VBA. The table 'tbl_bank_deductions' is the original data as imported from the pay system. The table 'tbl_bank_deductions_final' is what where I need to get to. The final result can be either a table or query as it will be joined to a much larger query.
Part of your job as a developer is to produce the result the client is looking for. If they had the skill set and knowledge to design and develop the system on their own then they would not need you. They know what they want it to do and they have ideas on how you should do it, your job is to show them the correct way of creating the system to produce the results they want.
If you don't do this and you just blindly follow their advice on how to design the system it will come back to haunt you. For example, when they request a query that cannot be generated due to their faulty design, you will still be expected to make it work.