Search results

Thank you Ranman256. How do I total the parts subform? If I have more than 1 part associated with the repair and I do the =sum([Quantity]*[UnitPrice]) in the subform footer, I only get an answer for 1 part. What am I missing?

Thanks plog. I have that other table already, see attached png file. I would like the report to list all repair orders by unit number with totals for parts,totals for labour and a grand total for each repair order. How do I enter the SQL statement into a query?

Thank you for the quick reply plog. As I stated, I am a virtual newbie in Access and have never been involved in setting up a relational database, so bear with me. This database will be for my sons small trucking company (only 5 units so far). It starts with a Vehicle table which is linked to...

Hi There. I am a real newbie with absolutely no access experience, trying to muddle my way through setting up a work-order type database. I have set up a table for work-orders with a general description of the repairs affected. I have a form set up to enter the info, which contains a tab...

Thank you guys! I have been lurking here for a few days and reading some of the threads, and they are so far over my head that I'm wondering if I took on too much trying to do this. I am a 72 year old retiree looking for something to occupy my time and boy did I pick one here! I have no...

Hi Everyone, just a short post to introduce myself to the forum. I am a new user of Access 2010, and know absolutely nothing about relational databases. I am truly hoping that all of you will bear with me in the coming weeks and months while I try to develop a database for my son, who...