G
Guest
I have created two tables, multiple queries and multiple associated reports.
When I currently run a report I have to differentiate last names (Smith1,
Smith2, etc) for my reports to collect data properly. If I could some how
combine both first and last name to create a unique identifier ( I do not
have a situation where both first and last names are the same) my reports
would print out Smith instead of Smith1.
I used the Access Wizard to reate my Tables, Queries and Reports and have an
extremely limited knowledge of SQL.
Any help would be greatly appreciated.
When I currently run a report I have to differentiate last names (Smith1,
Smith2, etc) for my reports to collect data properly. If I could some how
combine both first and last name to create a unique identifier ( I do not
have a situation where both first and last names are the same) my reports
would print out Smith instead of Smith1.
I used the Access Wizard to reate my Tables, Queries and Reports and have an
extremely limited knowledge of SQL.
Any help would be greatly appreciated.