Another control affecting the output of a control

[June7]

If the Final_Vote is a calculated value, why is there a field in table?



Very odd - CR72-75 should show Approved.

I created a new query to test the expression. It works. CR72-75 show Approved. So there is something about the report structure.

I am looking at report Weekly SITREP PPT. Why is the RecordSource an aggregate query - there are no aggregate calcs. I removed the grouping and no change in report output.

More oddness. CR72-75 are the only records in the report where Action_Complete is False. Only two other records (601, 602) in the table are also false but they aren't even in the report. Also 145 and 146 are True in table but False in report RecordSource query. 145/146 show Hold when there is no value in 06_Vote.

Summary query is the most complex CROSSTAB I've ever seen.

Weirdest issues. Ever.

I can't find the cause. Suggest you rebuild report from scratch, little piece at a time until see the same issues. Start with a simple query of the table that shows the correct Final_Vote calcs.


Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Date_ID is better than DateID'd.

[Thompyt]

CR72-75, 145 & 146 are still in open status, a decision has not been made yet. The reason its an aggregate query is because I was trying to cut down on the actual query tables. Remember this is one of my first dB's I have done. I just started playing with Acces for this. if you look at the Main table CR145/146 both have Hold in the O6_Vote value. I think the difference is that 72-75 are level 1 CR's and do not require a value in the O6_Vote, thus it is null/blank. There might be a requirement to make a if O6_Vote isnull then value = AO_Vote. ??

CR72-75, 145 & 146 should not have Action_Complete enabled as they have not been completed. When the Final_Vote is filled in then the Action_Complete will be enabled.

I'll take out the groupings and give it a run. Make it simpler.

Summary Query was done by me and access. It was a pain to get it going the way I wanted.


Thanks June

[June7]

I did look at Change Request table (the only data table in the db). The data is as I describe. Wait, there are CR_ID and CR_No fields. I was looking at CR_ID. Either way, 72-75 does not have data in O6_Vote. CR_No is used in the report. CR_No 72-75 have "Hold" in AO_Vote. Hold is not a value to consider for AO_Vote field in the Switch expression, therefore it returns Null.

[Thompyt]

Ahh 601/602 = CR 145/146. What do you mean they are not in the report? They are not in the totals because they are not closed yet. Once they go into an Action_Complete Enabled, they will be added to the total for that week.

[Thompyt]

I did look at Change Request table (the only data table in the db). The data is as I describe. Wait, there are CR_ID and CR_No fields. I was looking at CR_ID. Either way, 72-75 does not have data in O6_Vote. CR_No is used in the report. CR_No 72-75 have "Hold" in AO_Vote. Hold is not a value to consider for AO_Vote field in the Switch expression, therefore it returns Null.

I put the [AO_Vote]="Hold","Hold" in the switch. It now works. Good catch June. Thanks for the assistance.