Forum Discussion
Report with each week across the page
George_Hepworth - Thank you for your reply, the DB is in French so I will try to explain the tables
TBLcompany
- Company: name of the company
- Code: code assigned for the pay period use (A or B)
TBLhours
- Company: same as TBLcompany
- Name: employee name
- PaidOn: date of the period
TBLperiodA
- Week: Week number
- Period: Date for the period
- Code: same as the one in TBLcompany
Let me know if you need more information
Thank
Jeannie
Jeanne Cote Thanks, I'll work out a potential query that provides the desired output based on that exact structure.
- George_HepworthAug 04, 2020Silver Contributor
George_Hepworth Unfortunately, that doesn't seem to quite make sense.
First, I would expect there to be a table of employees. I would expect that, instead of repeating the employee name over and over in that table, you'd use the Primary Key from that other employee table as the Foreign Key for the Hours table.
Second, you have a table, apparently, called TBLperiodA, and a field in that same table called "Code" which would, apparently, refer to either "A" or "B"? Is that the actual structure? If so, it implies a second table called TBLperiodB. And that would be inappropriate.
Can I see the REAL, FULL tables, with sample data please?My French is not that great, but I do speak fluent "Database" and I can make more sense of the actual tables.
Thanks.