Recent content by jstroh

David, I'd like to try that but I don't know where to put it. Can you help?

The following is what I used, but it brings up a comma use error. What do you recommend? Iif([text40]<4,2,iif([text40]<9,3,iif([text40]<12,4,iif([text40]>12,5)

It's hard to explain so I'll just ask. I have a datediff field on my report giving me the number of months an employee has been with the company. Now can I add a field that will allow me to show what level they should be at based on the result of the date diff. Example, 0-3 is level 2 4-8 is...

That was it, thank you. All my problems from that is fixed.

In reading my SQL up above they look the same to me. Can you find a discrepency?

Use the following code and you will get how old the person is in years. =DateDiff("yyyy",[Birthdate],Now()) Birthdate is the field name you have assigned to the individuals Birthday.

In my personnel data base I want to run a report based on the completed levels of training. I have 2 tables. 1 has all the employee information including the Job number. The other table has the Job information. I want the query to show all the training information including the job number...

Here is the SQL SELECT [Injury Log].Site, [Injury Log].Name, [Injury Log].DateOfIncident, Sites.JobNumber, Sites.Address, [Personnel Information].[Employee#] FROM (Sites INNER JOIN [Personnel Information] ON Sites.JobNumber = [Personnel Information].JobNumber) INNER JOIN [Injury Log] ON...

How can I keep from getting the Join Expression error?

Now when I try to run a query to gather info from the Injury Log, Personnel Information and Account Information, it keeps giving me a join error. What am I doing wrong?

That makes sense, and is what I figured I would have to do. Thank you.

I am creating a Human Resource database and I want to enter an employee number into the workers comp form. Then the information from the employee table will be automatically entered into the injury log table. Is this even possible?

I am still struggling with my form that manipulates a query. I want a form that allows users to change a query's criteria so a report can be generated based on what the user requests. Where do I start?

The database is the people who have applied for a position with my company. What I want to do is search for candidates based on what days they are available to work and what their qualifications are. For example, I want to search for all the candidates who can work on Fridays, Saturdays...

I have created a query that will be the source for a report. I want a form that will allow the users to pick what of the query they want the report to reflect. I have the form already but it shows what is already there with all the information not a select type form. Any one know how I can...