I originaly put this post in the forms area. I was thinking It may apply beter to this one.
Ok, here is the query, and I know I haven't used proper naming, but hay that's just me.
SELECT Count([MISCELLANEOUS SUPPLIERS].ID) AS CountOfID
FROM [MISCELLANEOUS SUPPLIERS]
WHERE ((([MISCELLANEOUS SUPPLIERS].[CM RECEIVE DATE])<Date()-7) AND (([MISCELLANEOUS SUPPLIERS].[REL DATE]) Between Date()-7 And Date()-1)) OR ((([MISCELLANEOUS SUPPLIERS].[DISP DATE]) Between Date()-7 And Date()-1));
This, along with other from different fields, is displayed on a report. I need to be able to allow the user to add to the "count" qty (totals coming in from outside sources).
Any help would be GREATLY appreciated!!
Ok, here is the query, and I know I haven't used proper naming, but hay that's just me.
SELECT Count([MISCELLANEOUS SUPPLIERS].ID) AS CountOfID
FROM [MISCELLANEOUS SUPPLIERS]
WHERE ((([MISCELLANEOUS SUPPLIERS].[CM RECEIVE DATE])<Date()-7) AND (([MISCELLANEOUS SUPPLIERS].[REL DATE]) Between Date()-7 And Date()-1)) OR ((([MISCELLANEOUS SUPPLIERS].[DISP DATE]) Between Date()-7 And Date()-1));
This, along with other from different fields, is displayed on a report. I need to be able to allow the user to add to the "count" qty (totals coming in from outside sources).
Any help would be GREATLY appreciated!!