Search results for query: *

Thanks drlex!! I really appreciate your help! it worked for a specific entity and specific account number in my code below, however, when i tried to include a range of accounts and entities, it does not return records for the months where there is no activity. :( Instead of: (entityid =...

oooh, thanks! I tried a left join on the dates table as you have mentioned, and for some reason, it doesnt return the missing dates and only return records for those in my 2nd table (drill sum). I'm not sure what i'm doing wrong or what i'm missing? Melanie

Thanks Qik3Coder! I have created a Dates table, which holds all of the different periods that I am trying to get a balance for, but I am unsure of how to populate the empty records? Not sure where to go from here. :(

Hi, I am trying to create a running balance for 12 months, and have created the code below for reference. My query table is based off of a summary table (drill_sum), which totals all activity per month for each account number. This query works correctly, however I would like to include a...

There is no formula. I just used the field "group" field from the database. in this field, there are 4 different values, or 4 different groups, and there are nulls in this field for records that are not allocated to any group. if i dont include Budget in the summary field, i could surpress...

oh cool!! thanks LB!! you're sooo awesome!! :) Since I moved the Budget field into the summarized field, it added another "group" to the report where there are 0's in actual amount, yet there are budgeted numbers in Budget. I had surpressed empty columns so that this column of 0's in actual...

I have a report with 5 rows and 1 column(GRP), and have surpressed all of the subtotals except for the subtotal for Row 5. So the format of the report looks like the example below. is there a way to have a subtotal for Budget (row 5)or a total Budget Amount for each 'type?' row1...

Hi, I have a crosstab report with 2 rows (account ID and account name) and have surpressed the subtotal for account name so that account ID & account name would be on 1 line. The format in design view is as follows: design view: Total Cost Column 1(user defined field) Row 1...