Recent content by databasedesigner18

The sample of the Query result is attached.

How do I paste an excel sheet sample without it turning to giberish when I send it.

Here is a sample of the Query I created that shows the issue of two invoices w/same contract/task not combining. This is the same query I would use to update expenditures when new invoices are sent to AP.

Good morning arnelgp, Part-1 I did create a query before. However, I do need to provide a little more detail. Each contract/task may have multiple invoices per contract, meaning anywhere from a few records to at least 30. Additionally, the records could increase based on how many different...

Ok. Thank you. How do I do that?

Hi. I have created a database to track invoices across many different contracts. Each contract has multiple tasks over at least 3 or 4 years. Each task under a contract has invoices that are submitted for payment. Each invoice(attached to a contract and specific task, has the same...