Recent content by Jimee

That did it. Thanks bunches!!!!!!!

I have a statement in an update query that I have gathering some data frm a table. I'd like to get the first 16 characters and if the last on is a "/" remove the "/" how is this done. Here is the statement: UPDATE ElecTrayFitting SET ElecTrayFitting.Name = Left([ElecTrayFitting.Name],16)...

Thanks, that did it.....

I don't think that will help, the OK button is a windows "OK". When I launch the print routine in my module a print dialog pops up and I just want to have that automatically hit the ok button and print a report, it is not one that is programmed. Thanks, Jimee

I am trying to pass a return in a VBA program that is printing multiple reports. I have evertyhing automated except clicking the ok button. Anyone know how to do that?

Thank You Thanks. That did the trick

The same value all the way through The same value all the way through

I have a new field I havbe added to a table. How can I retroactively fill in the records automatically?

It is a real world challenge. Ther Rev_id is not really a prt of the orriginal database. Is it possible to do what is needed without that table. I'll send a virgin copy. 1. There are 2 tables with Identical fields. There are no unique fields, but one is from a database from some point...

That is close. What I need, is for this query to tell me what is different about the two tables. 1. If something is in one but not the other. 2. If a quantity has changed. Basically if there are any differences. I have attached the database with some differences.

Actually, I want to show the difference between the two tables.

I want an expression that will display data from fields only if they are different. Any suggestions? I have attached my database and the query is "A Query" Thanks....

Here is a copy of the database w/ the two tables. I need a report that identifies the different qty

Yes,

I have a database that gathers and coalates data from hundreds of individual databases. What I need to do is find a way to compare the data from one point in time to another. What I am going to do is initially run the coaliting database and name it Rev_A. Then at some point in the future we...