Darren has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Queries
I have used the query wizard to create a query to display the directors listed on a particular company, the data shows as follows:
[Company A Limited] - [Director 1]
[Company A Limited] - [Director 2]
[Company A Limited] - [Director 3]
[Company B Limited] - [Director 1]
[Company B Limited] - [Director 2]
As you can see from the above the query displays the information I want, however I don't want it to display the company name next to every director, I want it to display as follows:
[Company A Limited] - [Director 1]
[Director 2]
[Director 3]
[Company B Limited - [Director 1]
[Director 2]
Any help would be appreciated.
Thanks,
Darren.
RE: Queries
Hi Darren
Thanks for your post, I have had a look at it and I do need to consult with one of my colleagues, though they are training today.
We will be able to get back to you by Monday with a full response on this!
Regards
Jacob
