Recent content by Ajabu

MajP, that is very helpful! Thank you. Yes, I realised there are problems with the structure, actually wanted the entries all on one row but didn't know how to do that. From your examples, if I understand correctly, you're merging various column headers into one column. I would then fill that...

This will take me a bit longer to figure out in my situation. But I appreciate your help, Gasman. Will update or post a follow-up question if needed. Thanks for your suggestions.

I have three main categories which affect salary: Paid absences (eg including paid leave) Unpaid absence (eg absent, sick) Other factors which impact salary (eg Staff loan, bonuses, training) – may or may not be paid. Would you advise that I create three (possibly four as the third category...

Thank you Gasman. I am thinking that I'll have to sort this out with Subqueries as you suggest. Not quiet sure yet how I can structure the data better (or the queries) but will have to do that. Pat Hartman. Yes, the report is just using one query. The problem is some of the fields are empty as...

Gasman, thank you for your response. I'm not following. What do you mean one report for the right and one for the left? If you're talking about the two payslips I showed next to each other (one right, one left), those both have the same information in them; the one on the left just had all the...

I’m trying to create pay slips which not only include the standard deductions but also itemise any additions/deductions which affect the salary. The number of additions/deductions can vary for every month and employee. How can I create a report which includes this information but without big...

This is another possible way around the problem. I can get this table with a query: But how do I get rid of the double entries per month? Filtering out the “Worked this month” doesn’t work as it would also remove those employees who didn’t have any absences (Ben Gerard and Dave Black in January).

Thanks for your input Gasman. I have not included any salary numbers in my sample database as any deductions are simply a calculation matter. I shouldn't have any problems doing that. My problem is including the reasons for absence for each period of absence. When I include an absence column...

The numbers are just dummy figures. You picked up a mistake which I didn't notice. Sorry about the confusion. I believe I have included sick leave with deductions so not sure what you mean.

Yes indeed, the second table is not an actual result from Access; I created that in Excel. But that’s the result I need. In order to be able to give the REASON for the absence in the report, each absence needs to be listed separately if I understand things correctly. That’s also the reason why I...

I would very much appreciate some help. I want to create payslip reports for each employee. In addition to all the expected information I also want to include information showing the reason for any absences. I’m having problems listing the absence comments. I’ve created a query...

Thanks all for your feedback. Good to learn more. I have found the problem. The resolution of the other computer was a red herring. It turns out that when I transferred the amended database back to the original computer the page setup settings had changed. Using another computer made the...

I have found a possible solution for this problem though it doesn't fix everything. Select the properties for the form, then change the option "Layout for Print" from Yes to No. And with that all the numbers are suddenly all visible again. No more ###. That solves that problem. But Print...

Okay, another strange thing I've found. Rather than recreate the whole database from scratch, I started a new one and pasted the original tables, queries, and reports into the new database (data + structure). That fixed the problem; the numbers appeared again as expected in the textboxes --...

Okay, I have a strange problem. I have an Access database which I transferred over to a laptop with a very high screen resolution. When I copied the database back to my desktop all the textboxes in the reports show no values but instead just show #. If there's one number present I see #, three...