Search results

I thought I had learned enough about Access over the past month, guess I thought wrong. Building an HR Data Base using EmployeeID as the Primary Key. I have a Personnel Form with a Tab Control. The tabs consist of multiple fields from different tables relating to the Employee, like...

I produced a query in the end and got the results I needed.

I have a problem getting the value of an IIF function that produces a DateDiff. Instead I'm getting numbers stored as text, and when I try to sort the report, the numbers are all over the place. I tried the Val function on the DateDiff, but this only produce #Errors in certain fields...

I don't have much Access experience, but I have seen some awesome databases before and it what initially got me interested in them. I work in the HR field. I am currently working on an independent database of my own to help my office with consolidating all the records and reports we work...