Recent content by mkopsick

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?