Search results

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...

I have a report which displays Surname, first name etc etc, when I run the report it is not showing surnames which are duplicate, for example Carol Smith, Vince Smith, it only shows one Smith surname for some reason........and not the rest.....WHY? Also the report shows employees "Trained In"...

It is possible to set a report to automatically print on a weekly basis by a too from date range? Im fairly new to Access so I dont really want something too complicated as I wont be able to set it up. :confused:

Can someone help please, I have this error message come up each time I open up the DB. Its says: The form name "Contacts" is misspelled or refers to a form that does not exist. I have 2 Macros which do not have that name in, I have searched high and low and cant seem to fix the problem...

I have found it.....

Hi all, I am a newbie to Access and I need some help on the Tab control function. I have my tables in place etc and I have created a tab form, my question is when I add a Comb box or list box how can I locate the information I have in my tables......I just cant seem to find out how to do...