Query help needed!!!

[dr_shiva29]

Hi,

I have 2 columns in my table from which I want particular information:

Column 1- Date "my company" received document
Column 2- Date "my company" processed the document

Could someone help me build a query on the number of documents which were received and processed on the same date?

Would be grateful ever so much.

 

[pbaldy]

Try

SELECT ...
FROM ...
WHERE ReceivedDate = ProcessedDate

 

[dr_shiva29]

Thanks. The suggestions seems to have worked but I have walked into another block now. Now I am able to pick out the records where the "received date" and "processed date" are the same. But this also gives me redundant information, for example, if there were 3 documents which were received and processed on 1st April, I am getting 3 rows with 1st April in both columns.

What my query should present is one column as "Receipt Date" and another column with total number of documents. Taking the above example, the query should return me a result like below:


1-Apr-10 3
2-Apr-10 2


Once the above is done, is there a possibility to retrieve the data for a date range from this query?

As always, many thanks in advance for your help. I am really running short on my timeline to complete the database and hope this issue resolves. Just for information, I do not have knowledge of VBA and have built the database completely with the help of tools in MS Access.

 

[John Big Booty]

You can use;

Between #1/1/2009# AND #1/1/2010#

in you criteria to return results between two dates. Simply set your dates as appropriate.

 

[pbaldy]

And as I told you elsewhere, Count(*):

SELECT DateField, Count(*) AS HowMany
FROM...
WHERE...
GROUP BY DateField