Hi,
I could really use some help.
Here's the general scenario:
I am the Project Manager, managing a project for my client.
I have multiple vendors
They bill me for work on various subprojects (called CDs) within the project.
I then bill my client, providing them with a summary of the billings , grouped by CD and Vendor.
All vendor bills (hours and material) are entered into a table WO (Work Orders) and classified as 'Pending'
When I am ready to bill them to the client, I append them to a table Bills, which has the following fields:
WOID (Id number of the work order that was billed)
DrawNo (which progress draw this was billed to the client under)
BillDate
BillAmt - appended from table WO
I run a report to show me what I billed the client for each billing cycle or draw, i.e. by the draw number.
Table Bills has items under multiple draws, i.e. Draw 22, 23, etc.
I want to run a report which shows:
Billing for Current Draw (by Vendor and by CD)
Total Previously Billed (by Vendor and by CD)
I have two queries, one shows me a list of all CDs billed, by Vendor, and one shows me only the current billing (i.e. where DrawNo is Max).
I want to combine this info to show it on a report as such:
CD # --- Vendor --- Prev Billed --- Current Billed --- Total Billed
Can't figure it out!
Any help would be greatly appreciated.
Sorry if its confusing, if any clarification is required please ask
Thank you!
Janzi