Recent content by GinaO

Hi , This is wonderful !! Just what i needed ! Now I only need to modify it to get the DSum for "ranking < " instead of "ranking <=" But it gives me an error saying "data type mismatch" when I try to make the change. Is there a way around this? Would really appreciate the help . Thanks...

I've been at this for days and still can't get through. If my post wasn't clear i'm be glad to elaborate. But somebody PLEASE help !!!

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 ...

Hi, You could try writing two separate queries and then doing a union of both. I have the same problem & this kinda worked out. Hope this helps . Gina. :)

Hi Alan, did u find the answer to this? i have the very same problem. Thanks, Gina.

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...