Search results

this is my situation, i have three fields in a query susp days rec'd date susp act date the [susp days] is either "1 day", "4 days", or "10 days" the [rec'd date] is the actual date the record was entered the [susp act date] is the date the suspense is due based on which selection was...

can i do this? [susp days]="4 days", DateDiff("d",[susp act date],Date())<=3

im doing this in a report, i have the first condition [susp days]="1 day" where im using a different field that has "1 day" to change the color the second condition i have DateDiff("d",[susp act date],Date())<=3 and nothings happening

i did the condition for the 1 day would i use a datediff like this for the 4 days? If DateDiff("d", susp act date, date()) <= 3 Then trying

is there a timer function?

i want the 4 day one to turn red in three days and the 10 day one to turn red in 8 days so i know there coming due make sense at all

wouldnt i use if then for one day if "susp days" = "1 days" then "susp act date" turns red. for four days if "susp days" = "4 days" then subtract one day from "susp act date" and turn red. for ten days if "susp days" = "10 days" then subtract two days from "susp act date" and turn red.

it does but we enter dates everyday...so i have to compare the rec'd date to the susp act date to determine if its 1,4,10 or i have a field that says 1 day, 4 days, or ten days and based on that and the susp act date determine what day to turn the text red....am i making sense to you?

i have three fields to work with "rec'd date", which is the current date the record was entered, i have "susp days" which puts in the number of days i.e. 1 Day, 4 Days, or 10 Days, and the "susp act date" which has the date in it according to how many days were selected for the suspense. so i...

i also have a field in the table that says 1 day, 4 days and ten days that colaberate the date

well one more thing..i want if its "1 day" to turn red instantly, if its "4 days" i want it to turn red on the third day, and if its "ten days" i want it red on the eight day. i really appreciate your help...you guys are the Best

how could i write the expression to use in the condition to compare the dates? I.E. 05/27/2009 and lets say its the 4 days susp date i need it to turn red on 05/31/2009 and stay that way.....help?

i used this in my form to store the dates... Private Sub Combo36_AfterUpdate() Select Case Me![Susp Days] Case "1 Day" Me![Susp Act Date] = Date Case "4 Days" Me![Susp Act Date] = DateAdd("d", 4, Date) Case "10 Days" Me![Susp Act...

is there a way to run something on the table and have the text color changed in that field based on a date it reaches?

appreciate the reply, but like i said im a novice....i have the date part working and the result stored in a table....so do i use the functions above on the form side or the report side?

Ok Access guru's i need your help once again! I have a report that shows a suspense date in it. This is what im trying to do, we have three selections we use on the form when we input the dates. the first is "1 Day" which i need to turn red instantly, the second choice is "4 Days" and i need...

Got an easy way in mind that i can make those dates red in the report prior to the date ex: 1 day is red instantly, 4 days gets red on the third and 10 days gets red on the 8th day from when they were entered in the susp act date field in table1.

AWESOME! that works great! now on to my report adventure with turning these things red....LOLOL SOS you ROCK!

i use querys for the report i have but im pulling info in the query from fields in my tables....when i used the control source code in my form for that text box it works great but how will i save the susp act date again please excuse my ignorance here

excuse my ignorance please but wouldnt i have to store those dates and run the query? we will be entering dates everyday and need to keep track of them?