I think I figured it out. . . I used the following in my control source:
=IIf([DaysOverDue]<=0,"On Schedule",IIf([DaysOverDue]>0,[DaysOverDue],"In Progress"))
Thanks for all your help.
The report displays the actual value of Days Over Due if the value is greater than 0 which is what I want. But if the value is less than zero it displays On Schedule,On Schedule,In Progress. I just copied and pasted what you had into the format property.
I have some values that are null...
I couldn't get what you suggested to work. Not sure what I did wrong. I have the days over due already calculated in a query. I used that as my control source and for the Format property I put in what you suggested and when the report is ran I get - On Schedule,On Schedule,In Progress.
In...
I'm not actually sure how to write case statement in Access. I have a report that has a scheduled completion date, completed date, and days over due. The days over due is the difference between the scheduled completion date and the actual complete date. On my report I want to display the...
Ok Heres the situtation. I need to show a list of customers who have a invoice date that is 2 years or older or they have a last ship date that is 2 years or older. I'm using the max function on the last date ship since there are several shipping dates and I need to get the lastest ship date...
Both of the application.cfm are now named the same and everything works fine within the same addressing such as
secure.name.com/app1 then automatically logging into secure.name.com/app2 however,when I test the program like how the customers access sites with 2 different domains such as...
By the way both applications have their own application.cfm file with sessionmanagement = "yes". I'm not sure if this helps with whatever information you may have. I really new to CF and going through lots of books but I can't seem to find anything for this type of situation.
Is it possible to have a user to login only once for one application and then pass their user name and password to another different application? I have an application where a few users use the same login and password for a totally different applciation (both apps reside on the same server) and...
Is it possible to pass data from a query result in one template to a form in another template so if a user clicks on link to another page, the form is already populated with information. If this is possible how? Would you use <CfHTTP> and <CFHTTPPARAM> to do this?
Thanks for any help that you...
I have a query that is displayed in a table. The table is very long. Is there anyway that the table headings can be repeated on everypage that is printed?
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.