Thank you all for your usefull comments!
Finally this was the solution:
------------------------------
SELECT * FROM tbl_planning AS p
RIGHT JOIN
(SELECT date, ampm FROM tbl_date, tbl_ampm) AS d ON (p.planningdate = d.date AND p.planningampm = d.ampm)
Now I only need to get information about...
Hello,
I've some problems with the creation of a report in Access. I'll first brief describe the problem.
For our planning we have a table that contains the id of the employee, the id of the project, the date and the time (AM/PM). When I create a report for employee X, I only see the date (and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.