Need Help From The Experts (1 Viewer)

[zacharyjunior]

I have to report cost on a monthly basis to my staff. I built a database to record customer complaints, ship parts, and pay invoices.

The problem I am having is that if I record a customer complaint in Jan 02 and ship parts that day and a month later I pay an invoice against that complaint it show up in January 02.

In the invoice payment form I put an invoice date. In the complaint form there is a complaint date. My question is how can I combine both of these to give me accurate data. Keep in mind they are both date driven.

Thanks.

 

[David R]

Join them with a query, and sort by the complaint date? If your data doesn't need to be updateable (i.e. you're just making a report), that should work.

Otherwise, I'm not sure I understand the phrase 'how can I combine both of these'. You can use DateDiff() to get the time elapsed, but I doubt that's what you mean.

Post back if I'm not being helpful,
David R