Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding to query result (Count) with a user input

Status
Not open for further replies.

c4in

Technical User
Nov 14, 2002
5
US
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 &quot;count&quot; qty (totals coming in from outside sources).

Any help would be GREATLY appreciated!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top