Adding to query result (Count) with a user input

[c4in]

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!!

 

[Darrylles]

Hi c4,

A query queries a database for data in that database.

If you want additional data in the results selected by a query, then you must first add that data to the database - you can't do it at query run-time.

Let the user add data from a form first.

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot;