D
david.isaacks
SELECT Contacts.FirstName, Contacts.LastName, Contacts.Supervisor,
Contacts.Group, Contacts.Channel, Contacts.Title, Contacts.WorkPhone,
Contacts.WorkExtension, Contacts.EOD, Contacts.Status,
Contacts.ContactTypeID, Contacts.ReferredBy, Contacts.Notes,
Contacts.[Assigned Monitor], Calls.[Monitor Date], Calls.[Monitor
Time], Calls.Completed, Calls.Notes, Calls.Monitor
FROM Contacts INNER JOIN Calls ON Contacts.ContactID = Calls.ContactID
WHERE (((Calls.[Monitor Date])=[WeekOf]));
I have a report and I only want records from my query to return if they
are from the current week or the week that I run the report. A week
being Sunday - Saturday? I have be trying different Where statements,
but they seem to get me no where.
Any help?
David
Contacts.Group, Contacts.Channel, Contacts.Title, Contacts.WorkPhone,
Contacts.WorkExtension, Contacts.EOD, Contacts.Status,
Contacts.ContactTypeID, Contacts.ReferredBy, Contacts.Notes,
Contacts.[Assigned Monitor], Calls.[Monitor Date], Calls.[Monitor
Time], Calls.Completed, Calls.Notes, Calls.Monitor
FROM Contacts INNER JOIN Calls ON Contacts.ContactID = Calls.ContactID
WHERE (((Calls.[Monitor Date])=[WeekOf]));
I have a report and I only want records from my query to return if they
are from the current week or the week that I run the report. A week
being Sunday - Saturday? I have be trying different Where statements,
but they seem to get me no where.
Any help?
David