Hello all,
I have a form in my database. The purpose is to display returned data from a query in individual text boxes, and format appropriately via conditional formatting.
The query is 2 columns: EVDATE and MinOfSeverity (Returning the lowest value of the Severity column, grouped by EVDATE). The query works fine.
Each cell represents 1 day of the year. For now, I only did the first 10 days of January. In each text box, the control source is:
=IIf([EVDATE]=DateSerial([EVYEAR],1,1),[MinOfSEVERITY],0)
EVYEAR being a combo box elsewhere on the form with the current year in it. Later this will be used to change the year value in each formula, but right now it's default value is 2014.
Basically, what I'm trying to do is look down the query. If the value in the EVDATE column of the query matches the DateSerial value in that individual column, then return the value from MinOfSeverity. Otherwise, return 0. The conditional formatting takes care of the rest.
THE PROBLEM: For some reason, it will accurately return 1/1/2014's value as 0, and 1/2/2014's value as 5, however every other day is returned as 0 in FORM view. But if you look in the datasheet view, it returns the proper colors for each field along the record. (Basically a field of green with a line of colors going top left to bottom right.) I can't get the field to display the values properly for some reason. Does anyone have any idea why and what I can do to fix it?
I've attached a copy of the table/query/form to this post.
Any help anyone can give is GREATLY appreciated!! I've been racking my brains on this for a while now.
Much thanks,
Mike
(Really not sure how this thing is so big, has barely anything in it.)
DISPLAY.zip