This is probably a basic excel question, but I need to format cells to show text in red when the date in the cell is earlier than the current date. Thanks in advance.
As it is now....I just rclick the macro and select run. The dates come from the criteria in each of the queries that fill each of the forms being set to: between [From Date] and [Through Date]. I understand that my macro is opening up the forms and they are running just as I have desitned them...
Hmmmm. I'm not sure I follow. I don't use a form to call the macro....the macro itself is more of a push-button deal for my db. I want to just run the macro and have it know that the dates for all the reports it's set to print are the same. Is this possible?
Hi. I have created a macro in my database to print multiple End-of-Month reports all at once. My question is; How do I get the macro to print all the reports for a month without my having to enter the inclusive dates for each report? I just want to be able to enter the dates in once and let...
Thank you thank you thank you. Thanks to Bob and Vic especially. I used a little bit of what each of you suggested and had a little brainstorm of my own. The end result which acheived the desired effect was this:
Total Surgical Time: IIf([Time Out]>[Time in OR],DateDiff("n",[Time...
There must be something simple I'm doing wrong here. I put the expression:
IIf([EndTime]>[Cut],[EndTime]-[Cut],(TimeValue("23:59")+[EndTime])-[Cut]+TimeValue("00:01"))
In a field on my query. The query draws the numbers from a table where date fields are formated as...
Bob,
Thanks for the help so far. I really think we are getting close. However....I have tried each of the last expressions you sent, changing the field names to match mine of course, and still no dice. Could it be because I am trying to accomplish this in a report instead of a form? Just...
Thanks to all for the advice. It seems that most people feel that I need to add a second date in order to create an expression that will work for me. I would rather not have to do this since it would require 3 additional fields on my surgical case report and no one likes to type in dates that...
I thought my problem was solved with the post from VicLavigne. The expression is exactly what I need, however...I don't think I put it into the db correctly. I replaced the previous expression, DateDiff ("n",[Time In OR]-[Time Out]) and what I got was a number not relating at all to...
I have a database at work to calculate surgical time lengths in minuts. My problem is that when the elapsed time goes past midnight, I get a negative total. The db is reading the two times on the same day. For example: Surgical date 1 Sep 03, start time 2300, stop time 0200. I need this to...
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.