Search results

CJ_London That did not allow anything to come up. Tony

Paul I did not use any VB, still learning that. I did my from set up through property. Is there a spot that I go to in the property sheet to enter that code?? Tony

How do I do that, I am new to this. Thank you for responding. Tony

CJ_London Would I delete the other SQL or add that in??? Have not worked with the SQL area before. I really do appreciate your help. Everyone on this forum is so smart. Tony

Hi CJ_London Is this what you need? SELECT tblScrapLog.ScDate, tblScrapLog.Shift, tblPartInfo.PartNumber, tblScrapLog.TotParts, tblScrapLog.BadForm, tblScrapLog.Dirt, tblScrapLog.FinTrim, tblScrapLog.Foil, tblScrapLog.Scratch, tblScrapLog.Webs, tblScrapLog.Other, tblScrapLog.TotalScrap...

Hi CJ_London I was building a query, no coding. I am still new to this. I had put each of the part numbers under each other in the Criteria area. And the date asks for a specific dates. Everything works, in giving me the four part numbers that I need, but it gives me every date. I only...

Hello I had used a form to come up as a popup, and on that popup, the person can chose a report to go to (button). Is there a way that once they chose the button they want, to make the popup to go away automatically? Thank you in advance. Tony

I am trying to get my query to do the following: for my part numbers, I want to be able to only get my four part numbers and only see those on a chosen date. When I enter the four part numbers under the criteria, and I chose a date, then look at the data, I get the part numbers that I want...

It was in my query. Thank you

Got to work. Thank you very much.

I put that in, and I get this message: Syntax error in query express 'First([Sum([TotScrwBlank])/Sum([TotalAmount])])' not sure why,

Not sure what I am doing wrong. I have two columns in my report that at the bottom it gives me the following total, as I put below. I am trying to take the two totals that is gives and get the percentage. 1058/3024 = 35%. =Sum([TotScrwBlank]) =Sum([TotalAmount]) .349 or 35% 1058 3024 I had...

Not sure why this is doing this. When I print out my report, it will print most of the items, and leave some out. When I go back and check the information is in the database correctly, but it wont print out. Not sure what I am doing wrong, or is there something that I am missing. Please I hope...

I am trying to put my Month groups, ex: Oct, Nov and Dec which are already separated, but would like them to be printed on its own page, how would I force it to do that. Thanks in advance.:p

Thank you very much, that worked. Thank you, thank you.

Is there a way that say a person wants November and December, then when my report prints it looks like this: November number number December number number then a grand total of the column. My question is, is there a way to have it where November would have its grand total, and so would...

Thank you. I used that in some parts, forgot you can hide things? HaHa.

The Logo, and company name is already repeated on each pages, what I am trying to do now is that with my reports that have long data, I want to also carry the titles of the fields to each page, so you know what those columns are without keep flipping back to the front page. Example Scrap Date...

Hello, I was wondering if there is a way to just take the totals out of my query, and have just those totals display in my report. I am not an advance users so please the simplest way would be nice.:eek:

Would that let me keep that worksheet, so that each time i request different dates it would print the data in the excel, or will i have to always send it there.