Recent content by Stillpause

I have a table linked to an SQL server and the column that contains the data I need has a reserved symbol in it. So Access does not read the full name of the header. The header name is "IO_VALUE_RECORD&FLD" is there a work around for this so that when I query the table it will recognize the "&"?

Great, Thank you for all your help.

Thank you very much for the help that did the trick. One other question is there a way for me to get repeat values to show up. It seems to be using an automated DISTINCT function and dropping any duplicate values.:)

I am still fairly new to Access and have looked everywhere for an answer to this. I am working with Access 2002 and am also working with a non-relational database. This is my issue: I have a query with a date/time column and four number columns. Example: Date L1...