Report question

[Guest]

Hello,

I have created a report where one of the columns is "Status" where the
status can be Valid or Cancelled. I want the sum of the Valid and Cancelled
separately because then I have to subtract the two and get an average. Also I
would like to know how I can get these results on a separate page. I would
appreciate any help with this problem I am having!
Thanx

 

[Guest]

Hello,

I have created a report where one of the columns is "Status" where the
status can be Valid or Cancelled. I want the sum of the Valid and Cancelled
separately because then I have to subtract the two and get an average. Also I
would like to know how I can get these results on a separate page. I would
appreciate any help with this problem I am having!
Thanx

Hi,
Use DCount function to do this.

In report footer add two text box.

For textbox1, set control source property to =DCount
("Status","table_name","Status='Valid'")
For textbox2, set control source property to
=DCount("Status","table_name","Status='Cancelled'")

JB

 

[Guest]

Thanx a lot!

Hi,
Use DCount function to do this.

In report footer add two text box.

For textbox1, set control source property to =DCount
("Status","table_name","Status='Valid'")
For textbox2, set control source property to
=DCount("Status","table_name","Status='Cancelled'")

JB

 

[Guest]

Im sorry to bother u again but I get a message saying that I entered an
invalid character or omitted something
this is what I entered same as yours - I actually copy pasted it!
=DCount("Status","PCA_Cards_Table","Status='Valid'")
is my table name too long or something?

 

[John Spencer]

Try typing it in instead of copy/paste. Sometimes the posting will pick up
extra characters that get copied.

What you posted looks correct. If you still get an error, try posting back
with the actual error message.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

I typed it in the report and in another report just to see what would happen
- the error message is: "You omitted an operand or operator, you entered an
invalid character or comma, or you entered text without surrounding it in
quotation marks"
thanks

 

[AccessVandal via AccessMonster.com]

Hi,

Try with the square brackets, something like...

=DCount("[Status]","PCA_Cards_Table","[Status]='Valid'")

or

=DCount("[Status]","[PCA_Cards_Table]","[Status]='Valid'")


Is the table name with the underscore? Hope it's not corrected by Name
Autocorrect.

Note: "Status" is a reserved name in Access, it is used by ADO.

Im sorry to bother u again but I get a message saying that I entered an
invalid character or omitted something
this is what I entered same as yours - I actually copy pasted it!
=DCount("Status","PCA_Cards_Table","Status='Valid'")
is my table name too long or something?
[quoted text clipped - 16 lines]

JB

 

[Guest]

Thank u all for your help - but nothing seems to want to work here!! I even
went so far as to change the column name and the table name - and still it
does not want to work! The only thing I can think to do is to make two
separate reports and somehow get the results from both on the same page
somewhere.

Hi,

Try with the square brackets, something like...

=DCount("[Status]","PCA_Cards_Table","[Status]='Valid'")

or

=DCount("[Status]","[PCA_Cards_Table]","[Status]='Valid'")


Is the table name with the underscore? Hope it's not corrected by Name
Autocorrect.

Note: "Status" is a reserved name in Access, it is used by ADO.

Im sorry to bother u again but I get a message saying that I entered an
invalid character or omitted something
this is what I entered same as yours - I actually copy pasted it!
=DCount("Status","PCA_Cards_Table","Status='Valid'")
is my table name too long or something?

Hello,

[quoted text clipped - 16 lines]

JB

 

[AccessVandal via AccessMonster.com]

Hi,

Here's a link to MS on how to sum in a report.

http://support.microsoft.com/?kbid=208850