S
stephanie
I have a database that is linked to a report that is updated several times a
day. The table that the report generates is sorted so only the last record
per customer per day is displayed. I need to add a query where for each
customer we could add information like hours on meeting, hours on maintenance
etc. I would need to be able to keep that information on a table so I have
the latest record per customer every day. Here is the flow of the tables and
queries (to try and make it more clear)
Xls report append query to [Total Productivity]
[sort by time] (query to sort by the latest record per customer per day)
[Productivity by customer] (query to add customer name)
[append query] (to add hour to an additional hours table)
[total productivty with hours] (this table adds the regular hours + the
additional hours]
This is where the problem is. The more I update the table, I have duplicated
records for the same customer in the following query.
I don't know what to do!!!
Please help
Thanks
stephanie
day. The table that the report generates is sorted so only the last record
per customer per day is displayed. I need to add a query where for each
customer we could add information like hours on meeting, hours on maintenance
etc. I would need to be able to keep that information on a table so I have
the latest record per customer every day. Here is the flow of the tables and
queries (to try and make it more clear)
Xls report append query to [Total Productivity]
[sort by time] (query to sort by the latest record per customer per day)
[Productivity by customer] (query to add customer name)
[append query] (to add hour to an additional hours table)
[total productivty with hours] (this table adds the regular hours + the
additional hours]
This is where the problem is. The more I update the table, I have duplicated
records for the same customer in the following query.
I don't know what to do!!!
Please help
Thanks
stephanie