Search results

Excellent decision! Thanks for the feedback. Did you use the thread tools at the top of the thread to mark this thread as Solved?

To change a field in a table with a query requires either an update query or an append query. You are using a read type query (Select). Maybe if you describe what you are trying to accomplish (without using any jargon we won't understand) someone could offer another approach that would work for you.

The Nz() function does not change a field, it just changes what is returned from that field if the field is Null.

Thanks for the update.

Have you tried using Nz()?

Have you considered using a temporary table?

Welcome to the Forum and have fun.

Thanks once again Doc. The depth of your knowledge is astounding.

Hi Colin. I'm on most every day, just don't post that often any more. Always enjoy your stuff!

What a great looking dog. Majestic almost. Thanks for the post.

I thought I recognized the dog. :D

Welcome. Glad to have you on board.

Welcome to the Forum. Enjoy!

Welcome. Jump in whenever you have a question.

Cross posted at: http://www.accessforums.net/showthread.php?t=73177 Please read: https://www.excelguru.ca/content.php?184

Welcome Roger to this forum.

Thanks for the post.

I'm not really sure but I would try 1-3 rather than 1 to 3. You could also create a Public function in a Standard module that uses the Select Case structure if you wanted.

How about adding a calculated field to the query that uses something like Switch() to group the records for you to group on?

You probably already know Justin that computers are pretty dumb. They only know what you tell them. Mike has a pretty good idea on how you could tell the computer what surveys go with what protocols.