Yes, it works now. For some reason I didn't see the messages the first time I ran it. Sorry for the confusion and thanks for your help.

Got it....was missing parentheses.

This works

DECLARE @a INT

SET @a = (SELECT MAX(MasterID) FROM table)

Thanks for all of these ideas. They've helped me narrow the scope of what I need. I'm most interested in the amount of time that machines take to...

Being a programmer in the food sector is working well right now. People seem to be buying more of our products in these hard times...maybe going out to eat...

That's a good thought smunson, but for now I know that the table is referenced in several queries so I want to make it available.

Thanks

There error is:

Syntax error (missing operator) in query expression "Saturday' UNION ALL SELECT 2'.

I did some more reseach and found some posts that said Access does not support multiple records...

Works! I didn't know how to get the parameters to work in the "where" if they weren't fields. Thanks.

🙂

Thanks, but @ReportType is a value being passed in from the user. It's not a field in the Catalog table. Each type of report queryies the same table,...

Thanks for the advice. I've had the mindset of doing as much as I can in one stored procedure, but maybe in this case I should divide it.

Thanks