Question Listbox

[stevenb82]

I have a table of trainees. One of the fields of that table is 'authorized trainer' (YES/NO) tick box. What this allows me to do is query the trainees table based on who is an authorized trainer, and who is not. I have a table of called training, that records information about training a trainee has completed. One of the fields of this table is a lookup that looks up all the trainees from the trainee table who are authorized trainers, so that I can also record who conducts each trainees training.

As you can see from the table the listbox field for trainer shows both the last, and first name of the trainer.

I now need to export the table to an excel file, but when I do, only the second name of the trainer is exported. Is there a way to export both the first and last name?

Thanks in advance!

 

[Isskint]

Create a query and lookup the other part of the name and export the query instead.

OR

You could change the Dlookup() SQL to SELECT [LastName] & ", " & [FirstName] as FullName.......... This would return the name as a single field

 

[stevenb82]

Genius mate! Thanks a lot..