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...
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...
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 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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.