Search results

I'm kind of confused as well. But I think the requirement here is to log any shifts an employee has to do, while assigning a machine they will operate, there after, while you log the shifts for employees, a table or query might just be able to determine how much a machine has worked before it...

I did post the rest of question, it only said "You are an administrator in a plant hire business, create maintenance reports..." then there was all that detailed info I pasted in the 1st text/question I posted.

Please check the main question from earlier

"Data to be generated in Reports: *Maintenance of Machines/Equipment after (200 hours) *each vehicle *Maintenance of Machines/Equipment after (250 hours) *each vehicle *Fuel consumption/usage *all vehicles (Makes data set much easier to work with *Employee Performance *Day Shift (must help...

Thank You Paul

I'm on it, I guess I was only making this hard for myself by focusing on the end part of what I have to do.

How do I create a query (say I have assigned all my required tables) that will help me make calculations based on any of important data I have to input on an application part of my form, how do I come up with the functions or formulas for those calculations. How do I set my relationships when...

I've attached something I actually tried to do, there's a lot I wish I could understand - not good at queries and functions or even laying out how this can be structured. I can bet I will do better at the design (layout) part of this. My basic steps here was determining that Machine's and...

Maintenance Database Important Variable – Time Queries: · Calculate and flag maintenance of machines after a 250-hour cycle. · Create colored flags for each period, Green (between 0-100), Yellow (between 101-200) and Red (between 201-250). · Auto...

Hello everyone, I'm pretty much new to access but have had bits of basic knowledge for it for at least 5 years now. I'm more of a Layout Designer (very fluent in InDesign), Photoshop Ninja, Dreamweaver Student... actually anything Adobe is not so hard for me. I've always wanted to grow my...