Search results

Good Lord! Is that normal?

My query SQL was here and I learned something today.

The Date Field is SSEEndDate I would like the msg to say "In Prior to SSE"

My query is named ALLPersonnelQuery

Gina, I don't know what the SQL of the query is. I have the query open.

I'm trying to do this on a text box with a short date format.

And I put the text of my message between the quotes where you have "msg", right?

Dan, I'm not sure where to put the code.

Thanks Dan. I'll try it out.

I wasn't planning to. The reason is the same for all of them. I just don't want to have to explain to the auditor.

I have a field SSEEndDate I have some records in which this field is empty. What I would like to do is add a comment to explain why the field is empty on a report if possible. Click on it or move the mouse on it or whatever and the comment would show up. If this possible?

Many thanks. Worked like a charm.

I am trying to make the fields in the current month highlight if the date in that field is in the current month. It is to draw the managers' attention to those dates falling in the current month when they look at the report.

I have a short date field 5/20/2014 I would like to set up a conditional format to format those fields in the current month. For example, this month is would format all fields with "5". Next month all fields with "6" In the month space. I can't seem to figure out the expression, I know...

Thanks. Why not?

Solved. Thanks. Expression>Assessment Date and change the format to ddd

I have a date field in my table using short date (Assessment Date). I want to keep that and add a field in the table that converts that same date to a day of the week. I'm trying to use a calculated field in my table (AssessmentDay) and can't seem to get the expression right. Can somebody...

That's it. Thanks!

Thanks, This is the only condition. It's not formatting the column. I have some dates from 2012 (obviously more than 365 days) and it doesn't change the text or the background. I have the background set to normal, so I didn't make that mistake again.

Thanks CJ. It puts them in automatically. This is cut and paste from the conditional formatting window: Value >DateAdd("d",365,Date())