Totals in a report

[Guest]

I have a report that is filtered by a form. I need to be able to get a count
of the total amount of items in the table including what is being filtered.

Thanks in Advance for your help!!!

 

[Duane Hookom]

You can use
=DCount("*","[the unnamed item table]")

 

[Guest]

thanks, but i'm getting an error message.

You can use
=DCount("*","[the unnamed item table]")

--
Duane Hookom
MS Access MVP
--

I have a report that is filtered by a form. I need to be able to get a
count
of the total amount of items in the table including what is being
filtered.

Thanks in Advance for your help!!!

 

[Duane Hookom]

I'm having trouble seeing:
1) your actual table name
2) the expression you typed into the control source
3) your error message

--
Duane Hookom
MS Access MVP
--

thanks, but i'm getting an error message.

You can use
=DCount("*","[the unnamed item table]")

--
Duane Hookom
MS Access MVP
--

I have a report that is filtered by a form. I need to be able to get a
count
of the total amount of items in the table including what is being
filtered.

Thanks in Advance for your help!!!

 

[Guest]

I figured it out...Thanks a Million.....I was using the field name not the
table name.

I'm having trouble seeing:
1) your actual table name
2) the expression you typed into the control source
3) your error message

--
Duane Hookom
MS Access MVP
--

thanks, but i'm getting an error message.

You can use
=DCount("*","[the unnamed item table]")

--
Duane Hookom
MS Access MVP
--

I have a report that is filtered by a form. I need to be able to get a
count
of the total amount of items in the table including what is being
filtered.

Thanks in Advance for your help!!!