Recent content by scc

Thanks! Worked great! Always wondered how to add a module to the Normal.dot

Skip, Can you walk me through how I would go about implementing this code and then running it in MS Word? Thanks!

I have a document with lots of pictures in it. Is there a way to resize all the pictures at once instead of going through the document and resizing them one by one? TIA!

Curious where you find the Reset. I alphabetized my controls and I don't like it that way and would like to reset them back like they were originally (which seem to be most used at the top). Anyone know how? TIA

Thank you!!!! I had to "tweak" a bit, correcting a misspelled word and giving the Max column a name, but after that it worked liked a charm. I look forward to feedback from the Customer as it took the records for one day down from 269 to 27! Thanks again...

Thanks, I'll let you know when I get to this office whether this works or not... Here's a star for you efforts!!!

I'm sure it won't let me have 2 WHERE clauses on that last select. I'll try playing with it when I get in to the office.

Thanks for responding... I still don't quite understand how I would write the query to get all my other criteria as well. Is this what I would do? Unfortunately, I'm not at the office at the moment to try it, but will be in a few hours and need to get this resolved. Select * from FROM...

First of all, I just realized that I posted the following question in the SQL Server Group, but probably should have posted it here instead. Don't mean to "over-step" boundaries, but I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement...

As I'm reading back through my post, I realize I didn't state this correctly, so I will correct it. I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement, however there may be multiple records for a TrackingNumber. The TrackingNumber and...

I tried this, but get an error message that says "syntax error in FROM clause" and then highlights the word JOIN in the statement. Remember this is MS Access with a link to a SQL Server table. SELECT a.TrackingNumber, a.InboundDate, a.InboundUser, b.DeliveryDateTime, a.ScannedBy, a.Recipient...

I have the following SQL statement and there may be multiple records for a TrackingNumber. The TrackingNumber and the DeliveryDate (which has a time stamp in it) make up the unique key. I need to look at the most recent DeliveryDate and then check the criteria, but I'm not sure how to do this...

Exactly what I needed! Thanks!!

Can you give me a bit more info on how to do this? Thanks

I'm having problems getting either of these to work. dbomrrsm: I don't know how I can use a field to bring back the data instead of hardcoding it... mwolf00: this brings back an error that says-- The data type int is invalid for the substring function. Allowed types are: char/varchar...