I've defined a simple select query in Access that retrieves data for a particular date. I execute the query from VBA.Is it possible to pass a parameter into the query from the VBA when I execute ...

Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search ...

The easiest way is probably to create an Access VBA public function which takes the date parameters, queries the table and returns the appropriate count; and call this function within the UPDATE ...

Why re-invent the wheel? Here's a way to make consistent Access reports from similar data, while allowing your users to set their own data parameters.