Query two date fields?

zacharyjunior

Registered User.
Local time
Today, 04:40
Joined
Jan 11, 2002
Messages
26
I have two tables that I need to obtain data from. Both tables have date fields (Complaint date) and (Invoice Date). I want the complaint cost from June and all invoices from June.

Thanks
 
Use the Format Function.

RV
 
RV,

I am a little confused with your response. What do you mean by use the format function?

I have two diffrent tables.

Complaints (Which houses the complaint and orders are placed).
Invoices - Stores the financial data for invoice payments.

The orders are placed and the date is recorded when the complaint date is entered. I do not use a separate order date.

The invoice date is a separate date. This is done because an invoice may come in a month or two later than the date of the complaint.

What I need to do is get the cost of the order (Cost of parts shipped), and the cost of the invoice if there is one.

For example - I need all the order costs for June plus any invoices that were paid in June regardless when the complaint was recorded.

Thanks
 
You originally stated:

>I have two tables that I need to obtain data from. Both tables have date fields (Complaint date) and (Invoice Date). I want the complaint cost from June and all invoices from June.<

You seemed to ask how to retrieve the data in your tables for a specific month.
And you can use the Format function for this.

In your second post you're asking something completely different.

Now I am not sure what's your problem.
Are you asking how to write your queries, how to deal with a specific problem to get your queries to work or....

Rephrase your question and / or post your statements.

RV
 

Users who are viewing this thread

Back
Top Bottom