Search results

Hello, I am attempting to create a query that will allow me to sum all of the labor costs and material cost in the same query. Labor and material costs are stored in separate tables. However, when I do this I am running in to an issue where the sum values are wrong. I think this is because...

Hello, I am trying to create a query that shows that last time a vehicle was serviced but for multiple services. So the end view would be a matrix that would look like: Row - Equipment Number Column - Service Type Middle - Dates indicating the last time a piece of equipment was serviced for the...

Hello, I am having some trouble with a line of code: If rstBefore![Total] >= 8 Then OTHours = rst![Total] - rstBefore![Total] My issue arises when there is no previous recordset for the formula to look at. How can I add that in? I was hoping something like this would work but...

Is it possible to have an iif statement in a query that will count or sum as it runs, then when the count/sum reaches a value then it will do what you'd like. Example: If these are the results of my query Day: Job: Hours: OT: Mon 1 8 0 Tues 1 4...

Hello All, I am attempting to create a time-card data base that allows me to pull reports. I have created an example database attached that represents the one I am working on and I was hoping someone could help me with my current issue. OVERTIME Rules -Over 40 hours equals OT (no matter what...

Hello All, I am attempting to create a database for employee time card entry and I realized i have an issue with overlapping time. I need to find a way to prevent overlapping time per employees. My current database is set up similar to the example attached. If you look at table1 you can see...

Hello, I am struggling with this one..... and can't seem to find a good examples anywhere so I am hoping someone can help me out. I am attempting to have my database display the values in the textboxes that are too long in a pop up display when the users hover the mouse over it. The database...

Hello, I am attempting to create an open/closed view that will tell users if a job number has any open records. So i am creating a query to run through all the records for the job numbers and if there are any open records the query will show open next to that job number. Likewise, if all the...

I am having trouble with an IIF statement that i have in a query criteria: IIf([Forms]![FormName]![Combo1]="OpenOnly",No,IIf([Forms]![FormName]![Combo1]="ClosedOnly",Yes,IIf([Forms]![FormName]![Combo1]="Open&Closed", {{{{This is where my issue is. I can't close the IIf statement. I need it...