Search results for query: *

Hi, I've got a simple one, I think, but I can't figure out the solution. I have a table of data of purchase orders against which I have multiple receipt days. I'm trying to build a query that uses either the Max or Last total function on the date filed to determine the last receipt date. This...

Thanks. I got it now, and it works great! Greatly appreciated.

apparently I need a little more help. I copied both the above subroutines into VBA for the worksheet. Nothing is printing on the copies other than the data on the spreadsheet. I thought perhaps I needed to create a custom header showing the page number, but when I printed, each page showed...

Thanks for the replies. I can't wait to try these out!

I thought I posted this question yesterday, but cannot find it in the list. I apologize if this is a duplicated thread. Anyway, I would like to print multiple copies of a single page worksheet, but incorporate a formula whereby with each copy printed, a unique, sequential number is displayed...

Hey all. I played around with the "whileprintingrecords" function over the long weekend and got it to do what I wanted. It's a thing of beauty! Thanks for your suggestions and inspiration.

OK. I created the formulas as you stated. Put the @AccumScore formula in the details section and the @Display in the group footer. All seem to work well, in that the @Display actually displays the right value for the order based on the criteria. However, I still cannot perform a summary...

Thanks for laying it out for me. I'll let you know how this works.

Can you give me an idea of what that might look like? Will I then be able to perform a summary function on the formula? I'm outside of my comfort zone on this one, so the more specific the help the better. Thanks.

Can't get around this one. I am creating an on-time delivery performance report for my Purchasing Department. They receive large quantities of goods which can, and frequently do, take several days to receive over multiple shipments. It is my job to determine if, at some point over those...

Actually, that was my first choice, and I have done that with other, more complex reports. However, the identical tables linked into Access, and the query constructed the same way as the Crystal Report, ran like a dog. Slow as molasses. Actually ran more that 10 times faster in Crystal. I...

There is probably a simple solution, but I can't find it. I have linked an Access table to ODBC tables in an existing report. I am using the Access table to feed parameters to the Crystal report. When I did so, a dialogue box told me to go into report options to convert which database drivers...

Unfortunately, I am getting a compile error when I execute the command button. I put both the text box and command button in the report footer. Any ideas?

Thanks. I will try it and let you know how it worked.

I want to use a form to update a table with autonumber. How do I modify a form to create multiple entries into the table, which will have identical information, except for the autonumber, without having to enter the same information into the form repeatedly. In other words, I want to enter...

Thanks. That helps explain what is going on. I will try CLNG.

Can someone please tell me what's going on? I have a rather complicated query which draws information from many tables, including ODBC, and involves some calculations. I recently began getting an "Overflow" error when running the query. After hours of tearing the query apart, I...

Very minimal. Mostly macros in Excel. Do you have any simple models I might study? Thanks,

Never done that before. Do you have any examples?

That would make sense. I'm just trying to find a way to get the report to pick up all data since the last time it was refreshed and printed. Any ideas?