J
JHL
Hello,
Using ACCESS97
Trying to use DSUM for running totals in a query. I’m not very good with
SQL. I use the query design sheet. Read MS support article id 138911 on
this, but I get the same amount for my ‘runsum’ field. Other than the
RUNSUM, the only other field listed below that is numeric is the PAID field.
Field: CO Table: UI H Total: Group By Show: Yes Criteria: “PIâ€
Field: CARRIER Table: UI H Total: Group By Show: Yes
Field: PAID Table: UI H Total: SUM Show: Yes Criteria: <-4999.99
Field: Count: Count(*) Total: Expression Show: Yes
Field: RUNSUM: DSum("PAID","UI H") Total: Expression Show:YES
Field: CATEGORY Table: UI H Total: Group By Show: NO Criteria:
“RECOUPâ€
Field: STATUS Table: UI H Total: Group By Show: NO Criteria: <>â€Xâ€
Field: P-FLG Table: UI H Total: Group By Show: NO Criteria: Is Null
Any help on using this function would be helpful to future projects.
Using ACCESS97
Trying to use DSUM for running totals in a query. I’m not very good with
SQL. I use the query design sheet. Read MS support article id 138911 on
this, but I get the same amount for my ‘runsum’ field. Other than the
RUNSUM, the only other field listed below that is numeric is the PAID field.
Field: CO Table: UI H Total: Group By Show: Yes Criteria: “PIâ€
Field: CARRIER Table: UI H Total: Group By Show: Yes
Field: PAID Table: UI H Total: SUM Show: Yes Criteria: <-4999.99
Field: Count: Count(*) Total: Expression Show: Yes
Field: RUNSUM: DSum("PAID","UI H") Total: Expression Show:YES
Field: CATEGORY Table: UI H Total: Group By Show: NO Criteria:
“RECOUPâ€
Field: STATUS Table: UI H Total: Group By Show: NO Criteria: <>â€Xâ€
Field: P-FLG Table: UI H Total: Group By Show: NO Criteria: Is Null
Any help on using this function would be helpful to future projects.