Query Issues

A

Anthony

I have a query that pulls data by the date in which it was entered. The
query has functioned correctly for the last 3 months. I went to run the
query for February, and no information is returned. Any suggestions?
 
T

Tom van Stiphout

On Tue, 10 Mar 2009 18:12:01 -0700, Anthony

I suggest you post at least the SQL statement of that query.

-Tom.
Microsoft Access MVP
 
A

Anthony

SELECT [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID], Count([KYC - Master CIF
Violations].ID) AS CountOfID
FROM [KYC - Master CIF Violations] INNER JOIN [KYC - Master Branch List] ON
[KYC - Master CIF Violations].ID = [KYC - Master Branch List].ID
GROUP BY [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID];
 
A

Anthony

SELECT [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID], Count([KYC - Master CIF
Violations].ID) AS CountOfID
FROM [KYC - Master CIF Violations] INNER JOIN [KYC - Master Branch List] ON
[KYC - Master CIF Violations].ID = [KYC - Master Branch List].ID
GROUP BY [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID];
 
T

Tom van Stiphout

On Tue, 10 Mar 2009 19:04:02 -0700, Anthony

Hard to read with all the bracketed object names. But nowhere do I see
that this query is run "... for February..."

-Tom.
Microsoft Access MVP

SELECT [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID], Count([KYC - Master CIF
Violations].ID) AS CountOfID
FROM [KYC - Master CIF Violations] INNER JOIN [KYC - Master Branch List] ON
[KYC - Master CIF Violations].ID = [KYC - Master Branch List].ID
GROUP BY [KYC - Master CIF Violations].ID, [KYC - Master CIF
Violations].[Account Opening / Maintenance Date], [KYC - Master CIF
Violations].[CIF Employee], [KYC - Master CIF Violations].[Account #], [KYC -
Master CIF Violations].[Client Name], [KYC - Master CIF Violations].[CIF
Violation #1], [KYC - Master CIF Violations].[CIF Violation #2], [KYC -
Master CIF Violations].Comments, [KYC - Master CIF Violations].[Date Logged],
[KYC - Master CIF Violations].[Employee ID];


Tom van Stiphout said:
On Tue, 10 Mar 2009 18:12:01 -0700, Anthony

I suggest you post at least the SQL statement of that query.

-Tom.
Microsoft Access MVP
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate difference in rows on a form 1
Radio Button Value In Query 3
How to run a date based query for many months 9
Query Problem 1
query not showing all data for last month 3
Solve query? 14
Forms used to run query 6
Error Message for FORM/QUERY if wrong number entered 2

Top