Hello,
I am an experienced Excel and VBA user who is rather new to Access, though I do have some FileMaker (excuse the F word) experience. I am using Access 2000 SP-3.
My basic table setup (for the part we are interested in) is this:
I also am generating the following report (report based on saved query; query not shown):
Where Mark Brown, Andrea White, Austin Black, ... are all records in the Personnel table.
What I am needing to do, (both for simplicity and to save paper space), is to combine the Personnel names that are all related to a particular Engine-Cell record into one entity (perhaps an unbound textbox), so that instead of:
Brown, Mark
White, Andrea
Black, Austin
the report would read:
Brown, White, Black
on the same line. Or if you wanted to get fancy:
M. Brown, A. White, A. Black
but I believe I can do such extra string formatting on my own. Any help is greatly appreciated!
I am an experienced Excel and VBA user who is rather new to Access, though I do have some FileMaker (excuse the F word) experience. I am using Access 2000 SP-3.
My basic table setup (for the part we are interested in) is this:
I also am generating the following report (report based on saved query; query not shown):
Where Mark Brown, Andrea White, Austin Black, ... are all records in the Personnel table.
What I am needing to do, (both for simplicity and to save paper space), is to combine the Personnel names that are all related to a particular Engine-Cell record into one entity (perhaps an unbound textbox), so that instead of:
Brown, Mark
White, Andrea
Black, Austin
the report would read:
Brown, White, Black
on the same line. Or if you wanted to get fancy:
M. Brown, A. White, A. Black
but I believe I can do such extra string formatting on my own. Any help is greatly appreciated!
Last edited:
