S
Sam Santos
I'm using MS Query to pull data from an ODBC data source.
Everything works fine and I can extract data just great.
I'm wondering, however, calculating some fields with the
query. I can't seem to add a column heading without
enclosing the heading in quotes. That would normally be
fine, but everytime I go to edit the query and extra set of
quotes is added to the column heading.
Is there any way to get around this?
I also would like to know if there is a way to use
calculated fields in other calculations. If so, is there
any documentation out there on how to do this?
Thanks,
--sam
lalato at yahoo dot com
Everything works fine and I can extract data just great.
I'm wondering, however, calculating some fields with the
query. I can't seem to add a column heading without
enclosing the heading in quotes. That would normally be
fine, but everytime I go to edit the query and extra set of
quotes is added to the column heading.
Is there any way to get around this?
I also would like to know if there is a way to use
calculated fields in other calculations. If so, is there
any documentation out there on how to do this?
Thanks,
--sam
lalato at yahoo dot com