Search results

Thanks Paul and jdraw! I cleaned up the field names and got rid of the spaces, and that got rid of the [] brackets. I got rid of the alias, and found the two places in the report (text boxes in the report, as well as the sorting and grouping) that referenced the alias. And it all still...

Perfect answer! Thanks!

I'm new to SQL view, but I do a little VBA and other programming. When I'm looking at other details in SQL view, some have Table.Field and others have Table.[Field]. What is the reason for the [] brackets?

Thanks Paul! Exactly as you stated, when I look at SQL view, I see just what you posted. So the way to get rid of this (I'm trying to make it "cleaner") is to find where in the report it calls for the alias name and switch it back to a field name? Anything else I need to watch out for?

I am trying to figure out, and then update, an old database that uses a Query to populate a Report. In the SQL Statement: Query Builder that is used to populate the report, two of the fields don't have regular entries that correlate to fields on a table, but have a sort of "composite" or...

Dennis here from Colorado. Part time, occasional MS Access user. Still using 2000. I'll post my real first question over in Queries. Anyone have any strong preferences on upgrading to Access 2010 or 2013? Most of what I've read says there isn't a good reason to upgrade. Thanks in...