Recent content by imright

Thanks, it took me a while to figure out the difference between headers but it worked great!

I have a report that has several blocks of data that normally will fit on one page. If I have a lot of data that expands the blocks enough all the detail data below the header will print on the second and/or third page. How can I set up my report so that the detail information will stay on the...

Thank you for your reply. I'm really not a strong Access user so forgive my ignorance. You told me to put in some code but I'm not sure where. In the Query under VendorName? Does it go in the properties or do I build the code? Thanks again.

After reviewing my query that I set up I found a major flaw so my first post was inaccurate. :) I've attached the new query to show what I do have. What I'm looking to do is create an average of each suppliers quality rating for the past 12 month period and be able to create a new report the...

I have a database which tracks ontime delivery and rejects by suppliers. What I need to do is be able to group the data from each supplier for a years time so I can find the percentage of on time and percentage of rejects. I've created a query that when I went to Summary Options it allows me to...

This is the first expression: Expr1: IIf([DAYS LATE]<=0,0,1) Second:Expr2: 100-([Expr1]/[Count Of Suppliers])*100 Third:Expr3: 100-([Rejects]/[Count Of Suppliers])*100 And Last which gives me what I need: Expr4: ([Expr2]*0.4)+([Expr3]*0.6) I need the first expression because the table has some...

This one should be easy for all you brainiacs out there but it perplexes me. I have a query where I'm calculating two separate percentage by building an expression then I have to combine them to create a total percentage by taking 40% of one and 60% of the other. This works fine but seems there...

I tried this but did not work probably because I'm not sure where to put it. I had my query open in Design View and put it under the date in the criteria section but got a "Data Type Mismatch" error. Removed the name Format and received a syntax error message. Tried to create an expression with...

Yes, that's why I'm on this forum to learn. I'm signing off tonight and will try this tomorrow. Thanks for the information. I'll let you know if everything works for if I have more questions.

Yes, I have it set up to input the dates but I need the count of receipts by supplier per month.

This one should be easy but can't get it to do what I want. I have a query that tracks receipts from suppliers by the month. What I need to do is create a query that counts the total number of receipts by supplier per month. I've done this before but can't figure out how. :confused::confused:

Mike375 Thanks, works just as I wanted.

I have a form with several text boxes that at times requires large amounts of data, several paragraphs worth. What I need to do is be able to hit enter for the next paragraph without going into the next text box. Just as I did in this box or any Word document, hit enter for the next paragraph...

Tried that but got a Compile Error: "Method or Data member not found" and then .listbox was highlighted (& me.listbox)

OK, I'm going to try again and hopefully explain it better this time. I've created a database to create reports to track problems that happen within the company, each report is numbered in sequence. The report gets the data from a query so I've created a command button where I can input the...