It is also easier to use a local table instead of a # or ## temp table

Example to get log entries for today sorted by date/time descending:

DECLARE @tmpTab TABLE (

LogDate...

Hi...

I have worked with Access 2003 apd projects for many years, and have also used the projects on Win 7 without problems. I normally use a runtime version of Access...

Hi Nick,

Don't know for sure if this is what you ask for, but you can build your query in a string with the where clause and execute the string(query) with...