Heres one that is giving me fits ( = = Access newbie), more than likely
something simple that I blew right over . . . any help is appreciated -
I have a report based on a query, with several columns I need to work with.
Values in the cols are " Over " and " Under", as text values. The query is
for a start / end date, my count of records returned will be variable
depending on the runtime dates entered.
I need to count the number of " Over " , count the total lines , then return
a percentage " Over " in each col of the report ( there are 5 cols , Field
names [test_a], [test_b] ...[test_e] ) . Am I doing the right thing
attempting to " count " or do I need to take another approach ?
(count(test_a where val="Over") / count(*) x 100) // no attempt at
correct syntax here
for % Over is my goal. All my attempts are giving me " #Error " in the text
box I've placed in the footer.
Again, any help is greatly appreciated.