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...

Thanks. that works perfectly.

okay, could you please expland on that a bit. Do i put the calculation used in the coloumn in the record source, and how?? Then just use a normal sum function with the coloumns name Thanks

I've entered that into the report now, It gives me a total of the sums in the footer, i need a total of the "Hits" coloumn which is a calculation in itself.

Tried that and it didnt work, asked me to input the parameter for the summing. Attached is the database, the report in question is "EL Shipped Tonnes and Hits". Thanks.

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...

Re: Auto inout date for macros Thanks, that worked a treat.

Re: Auto inout date for macros i'll try that, how do i change the criteria of the query to use the txtbox?? Thanks

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...

sorry was me being stupid, couldnt find where you got a New txt box from. I worked it out, doesnt work if there is no data in any of the txtboxes. Thanks.

thanks that makes sense, stupid question, but that does that go in a txt box and how do i get a new txt box on 2010 as i cant find one. When i copy one i've already got and put that in nothing happens on the report.

sorry about that, basically three coloums with totals for each in the footer, i want a total of these totals. (as shown in the pic) Thanks

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...

I've tried that, sorry maybe wasnt specific enough. I only want to link the total parts produced not the individual part numbers and parts produced. At the moment the query doesnt save the information it produces and when i try to use "Make a Table" it just deletes the previous table and makes...

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...