Label error in Report

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I concatenated a field called grant number in my select
query. When I link my select query to generate a report my
grant id field label reads tblIMPAC.GRANTID and other
field label reads Expr1000. The report information changes
daily and when I link my query up to my report I manually
go into the design and change the information back to its
original field names which is: GRANT ID and FY(future
year). Is there a way to automate the labels in a report
so that they will remain the same as what was designed in
the query?
 
Allison

Without a way to look at the SQL statement, it could be tough to diagnose
what isn't working. If you have a query with a field label of "Expr1000",
that implies that you have MANY expressions in the query!

Can you find the field in the query labeled Expr1000 and learn more about
it? Can you post a copy of your SQL statement?
 
Back
Top