Recent content by Sharon1717

I must have a bug in my programme.......I have copied bits over to create a sample DB and its working ok.....................

I have done this and its not worked at all.....I have attached a screen shot

Hi I have attached a pic of what I have done, it dosent seem to have worked.....:confused:

Hi again, I have managed to get the report to look like what I want it to do. But......as its grouped by ID how do I sort the Surnames alphabetically? I have attached the latest report, take a look at the last name on the last page, one Smith surname but not listed alphabetically.....:o that...

Thanks its looking alot better now.....

I have fixed it I think, you can hide duplicates in the Properties Section of the Text Box, its starting to look ok now.....

I have attached the Grouped By ID report, as you can see its duplicating the Surname, First Name, Departments etc, but it has picked up all the Smiths so this report will pick up duplicate Surnames with different first names. Is it possible to have the report display only one line of the...

Hi, I have managed to group by Surname and First Name this seems to have solved the problem. Is there anything that I could do to have "Surnames" to show "all duplicates" whould this then show duplicated surnames with different first names?:confused: which is what I want.....

That does work but on alltering fields its not showing the persons training details directly under the surname/name in a list, if you know what i mean.... I would like the report to look like the attached: EMPLOYEE FULL LISTING TEST.pdf (85.6 KB, 2 views)

Yes i have grouped by Surname but if I remove this then the report does not show correctly the info I need which is by Surname.

Bob i have attached the query.

Yes the query and the report return the correct information but the report is not showing all Smiths for some reason, only showing one Smith but adding the other Smiths training info under the one Smith.

Hi Bob, thanks for that I have managed to get the report to show all employees whether or not thay have training. I still have a problem with the duplicate surname for some reason. There should be six individual smiths and the report is only showing one Smith for some reason and pulled in the...

REPORT INFO SELECT [Table Employee Listing MASTER].ID, [Table Employee Listing MASTER].[First Name], [Table Employee Listing MASTER].Surname, [Table Employee Listing MASTER].[Clock No], [Table Employee Listing MASTER].Dept, [Table Employee Listing MASTER].Manager, [Table Trained In1...

SQL Bits This is the SQL bit of the query I am using: SELECT [Table Employee Listing MASTER].Surname, [Table Employee Listing MASTER].[First Name], [Table Employee Listing MASTER].[Clock No], [Table Employee Listing MASTER].Dept, [Table Employee Listing MASTER].Manager, [Table Employee...