I can't review db until after 3/26. If you still need help then, add a post after 3/26 to get my attention.
I can't review db until after 3/26. If you still need help then, add a post after 3/26 to get my attention.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I am waiting June
Thanks in Advance.
Pankaj Michael
Dear Moderators,
Please help
Still suggest the approach described in post 4: build an aggregate query for each table (Production, TBEntry) then join those queries to Product table.
If you want to apply filter on the date field in each of the aggregate queries, then select Where on the Total row - the Show box will automatically uncheck.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.