Search results

  1. G

    nulls in crosstab

    Somebody please help me !!! I finally managed to get my data together correctly in my final query which is a crosstab. Now i want to perform a subtraction on the columns of the crosstab and because of the blanks/nulls my results are incorrect. eg. if i have 2 column headings in my crosstab ...
  2. G

    cannot convert null/blank to numeric 0

    HI, If anyone could help me on this i'll be indebted !! My report is based on a crosstab query which is based on a table. So column 3 in the original table is now spilt into columns #3 and #4 in the crosstab query. Some of the values in fields #3 and #4 are blank. I have to have a 5th...
Back
Top Bottom