DnGreenwood
asked on
Trouble with Left Function Use in Grouping
I am trying to group by first letter of last name in a report using the LEFT function and have a header at the top of each grouping of a letter. All the last names starting with A etc....
I have tried using this syntax but with no luck.. what am i doing wrong?
= LEFT([Last Name],1)
Thanks for your help!!
I have tried using this syntax but with no luck.. what am i doing wrong?
= LEFT([Last Name],1)
Thanks for your help!!
ASKER
used it in the Group/Sort Section and in a field within the Group Header
try adding the column to the record source of the report first
ASKER
Not sure I follow what you mean. Can you explain further... Thanks!
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect! What did you do? Was it simply you moved the grouping to the top of the order?
Thanks!
Thanks!
yes
ASKER
very quick response. Excellent help!
= LEFT([Last Name],1)
try adding a column to your query
select LEFT([Last Name],1) from table
group by LEFT([Last Name],1)