Search results

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

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

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

I’m trying to make an Access report look nice. I want to: hide zeros show whole numbers as whole numbers only (3 not 3.000), and show numbers with decimals but without any trailing zeros (3.5 not 3.500). I will list what I’ve tried as these options may help others in different situations. (1)...

I'm trying to count the number of workdays in a month, excluding weekends and holidays as listed in a separate table. In order to do this I'm using the function developed by Arvin Meyer: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer...

Hi All, I’m having some problems filtering for a date with DCount. My regional settings are set to European date format (dd/mm/yyyy). In my final code I'm using a variable for the date, but to simplify things I'm just putting an actual date in the examples below. If I look for the date number...