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

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

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

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

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

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

I want to create a report which selects only those records from the database which are after the date the report was last printed. I have tried using PrintDate as a criteria in my record selection formula, but turn up no data. And there is data to extract. What am I doing wrong? Thanks

Can anyone help me with the DLookUp function? I want to display, in a form, a value in a field, from a foreign table or query, based on the entered value of another field (control) on the form. My Access manual, and the help function in Access do not agree on the proper formatting of the...