Search results for query: *

That makes PERFECT sense, it is clear as mud (Smile). It seems so easy when someone breaks it down. I and I'm sure others will apprciate your explanation. Thanx so very much, Trudye

George, thank you so very much for your patience, professionalism and your understanding of what it is like to be a newbie to SQL Server. Also please accept my gratitude for taking your valuable time to explain the posted formula. I am sure I am not the only one who does not understand it. We...

Hi Guys thanx for responding so quickly. I make it a practice never to code anything I cannot support. I am new to SQL Server and I have no idea what you just coded. Although I appreciate the fun you guys had creating this complex formula, there has got to be an easier way to pull the month...

Thanks Guys so much for repsonding however, I'm don't understanding how the proposed options will get me the value I want from field ddbldt. I am trying to compare month values in an effort to get a specific year and month. Trudye

I have a date that is stored as numeric in format yyyymmdd. I am trying to extrapolate the month from it and compare it to the current date. Is there a way to do a substring on a numeric field? Here is my code: SELECT DDLOAN, DDprod, DDOFFR, DDBLDT, DDMFEE FROM...

Thank you so much for responding Skip but, I'm sorry I didn't get that. Trudye

Hi Guys, I found this function to convert julian date online but I'm having trouble getting it to work properly. S_Date = DateSerial(1900 + (rs1!PDATE \ 1000), 1, rs1!PDATE Mod 1000) after processing 2007184 S_Date is equal to 7/3/3907. which is bascially correct it s/b 7/3/07? What am I doing...

Thank you so much I will look into that. Trudye

Basically sends msgs to users. Here is the code: Function Time_To_Compress() Dim db1 As Database Dim rs1 As Recordset Set db1 = DBEngine(0)(0) Set rs1 = db1.OpenRecordset("Log_Em_Off", dbOpenDynaset) rs1.Edit rs1!Msg_Count = rs1!Msg_Count + 1 rs1.Update If rs1!Msg_Count = 2 Then...

Remou, thank you so much for responding so quickly. I have question, why does cnt jump from 0 to 3 on the very first pass thru the code? After this code is exec cnt is eq to 3(cnt = Val(Me![lblCountWarnings].Caption). I know I'm missing something just not sure what. Thanx, Trudye

Hi Guys, I am trying to execute a function every minute. It works the first time, the intervalTimer waits a minute before it exec the code the first time, after that it exec it every second. How can I get it exec every 60 seconds? Private Sub Form_Timer() Me![lblclockview].Caption = Time Do...

2003. Thanx so much BlueHorizon for responding but I figured it out. The fields were padded, I just needed to do a TRIM function. I still haven't figured out Current date, other than hard coding it in the letter. Trudye

Thanx Guys

Thanx for repsonding. That's not exactly what I was asking, let me try again. I want to assign "file types" not a single file. So in the future any time I open that "file type" the desired software is used.

Hey Guys, how do I assign a file type to a specific software? Thanx much, Trudye

It seems that they MS has managed to take a task that has always worked and screw it up. Leave it to MS. You used to be able to place fields in Mail Merge where ever you wanted and that's Exactly where they would print. Now it seems MS supersedes your placement with their own. Here is how my...

Thank you so much George for responding, but I jumped the gun on this one. It did the Update! HURRAY!! I had run it so many times (tweaking this and that) and it didn't work. It looked as it if was not working this time either. Thanx again for taking the time to respond, Be well, Trudye

HI Guys, I checked the Advance Search and fashioned my Update/Join after them. But for some reason it is not working. I created a SELECT query to insure my basic syntax was correct and it ran just fine. I ran a query in Access/SQL to insure my criteria was correct and I got back 2 records just...

I figured it out FINALLY. It woke me up last night, I need to add the TRIM function. I confirmed it this morning, in some of the records the first byte is a space. Thanx guys for all your help, Trudye

My mistake I forgot to mention the Acct_Number can be 10 or 11 depending on the Division. If the Division = 30 then Acct_Number is 10 bytes, if not it is 11 bytes. That's why the 8 zeros on if = 30. I put the DUH answer because I thought I had put the 8 Zeros on the Else. I gave the Stars and...