I HAVE A CROSS TAB QUERY THAT SHOWS ME THE NUMBER OF CALLS THAT CAME IN FOR EACH AREA
CompanyName Total 6100 6200 6301
Galaxy 71 2 0 3
GOQ 111 5 0 26
Mobil Home Park 4 0 0 4
I FORCED THE 0 TO DISPLAY USING @;"0" HOWEVER I THEN TRIED TO USE THE VALUES IN A REPORT AS A VALUE IN A CALCULATED FIELD AND IT WOULD NOT SEE THE VALUE AS A ZERO THEREFORE THE CALCULATION GAVE ME AN ERROR MESSAGE. FURTHER INVESTIGATION MADE ME REALIZE THAT I WAS USING A TEXT FORMAT AND THAT THE ACTUAL VALUE OF ZERO WAS NOT BEING STORED. CAN ANYONE ENLIGHTEN ME AS TO HOW I CAN MAKE A ZERO VALUE DISPLAY IN MY REPORT SO I CAN CALCULTE USING THAT VALUE?
ROOKIEDEV
CompanyName Total 6100 6200 6301
Galaxy 71 2 0 3
GOQ 111 5 0 26
Mobil Home Park 4 0 0 4
I FORCED THE 0 TO DISPLAY USING @;"0" HOWEVER I THEN TRIED TO USE THE VALUES IN A REPORT AS A VALUE IN A CALCULATED FIELD AND IT WOULD NOT SEE THE VALUE AS A ZERO THEREFORE THE CALCULATION GAVE ME AN ERROR MESSAGE. FURTHER INVESTIGATION MADE ME REALIZE THAT I WAS USING A TEXT FORMAT AND THAT THE ACTUAL VALUE OF ZERO WAS NOT BEING STORED. CAN ANYONE ENLIGHTEN ME AS TO HOW I CAN MAKE A ZERO VALUE DISPLAY IN MY REPORT SO I CAN CALCULTE USING THAT VALUE?
ROOKIEDEV