Search results

Hi, I have a query that shoudl produce information about the previous days production using several sub-queries. One of these uses information about the previous days two shifts which is entered into the database seperately and all the others are just information about the day in general. If...

Hi, I have a report which tells me how many of each part were made, reworked or scraped. At the end of each row there is a column for the number of hits which is the total of all these mulitiplied by a number in a hidden coloumn which is unique to that part. this is done by using...

Hi, I'm using 2010 and have a macro that runs three reports (just in the basic macro builder), when i run my macro it asks me to input the date i want teh reports to display for, however it asks me to this three times for each one. is there any code/way around this so i only have to input...

Hi, My report shows me 4 things in a table layout, Part Number, Amount Produced thats acceptable, Scrap, Rework. I have totals at the bottom of these columns for the last three things. I need a total of the last three things together so i can get a total made, how would i go about doin...

Hi, thanks everyone for the help. I have three tables (one for each production line) which people input data into everyday and the data is different each day depending on the part numbers and number produced. I want to create a report that shows me the part numbers and amount produced by each...

Hi, I have a database and an excel sheet which i want to link. The database is used to input part numbers and the amount produced, along with a query that can sum the total number of parts for a certain day and shift. The excel sheet records the total number of parts and any ones that were...