I have several columns across with a certain item and at the end of the
column there is a column title total how do I get the amount for the total in
it

> I have several columns across with a certain item and at the end of the
> column there is a column title total how do I get the amount for the total
in
> it

You cannot seriously expect us to be able to help you with so little
information.

Off the top of my head, it sounds like you should examine the Northwind
database that ships with Access, and have a look at the "Orders" and "Order
Details" table

You should be able to use an expression to calculate the total of an order
based on the unit price and quantity.

--
Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

"Avon Rep" <Avon (E-Mail Removed)> wrote in message
news:B0C211B3-91EE-4CEE-948E-(E-Mail Removed)...

>I have several columns across with a certain item and at the end of the
> column there is a column title total how do I get the amount for the total
> in
> it

This is an MS Access group not an Excel group.

Homer,

What makes you so sure that the OP is not using Access? They might very
well be using Excel, as you have assumed. On the other hand, they might be
using Access, in which case they have an incorrect database design. My only
input to you is don't jump to conclusions as to what software the OP is using.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"Homer J Simpson" wrote:

>
> "Avon Rep" <Avon (E-Mail Removed)> wrote in message
> news:B0C211B3-91EE-4CEE-948E-(E-Mail Removed)...
>
> >I have several columns across with a certain item and at the end of the
> > column there is a column title total how do I get the amount for the total
> > in
> > it
>
> This is an MS Access group not an Excel group.
>
>
>
>

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
news:4768591A-E702-4BFA-A353-(E-Mail Removed)...

> What makes you so sure that the OP is not using Access? They might very
> well be using Excel, as you have assumed.

Experience.

I see. While you may be correct in your guess, I think you're still making a
big assumption.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"Homer J Simpson" wrote:

>
> "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
> news:4768591A-E702-4BFA-A353-(E-Mail Removed)...
>
> > What makes you so sure that the OP is not using Access? They might very
> > well be using Excel, as you have assumed.
>
> Experience.
>
>
>
>

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
news:135F55C9-1283-4C5A-B288-(E-Mail Removed)...

>I see. While you may be correct in your guess, I think you're still making
>a
> big assumption.

20+ years of supporting end users? I'll stick with my guess until proven
wrong.

Perhaps you've been listening to your son, Bart, too much. I think your
daughter, Lisa, might have wiser advice for you.

By the way, you're not the only one who has 20+ years supporting end users.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Homer J Simpson" wrote:

>
> "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
> news:135F55C9-1283-4C5A-B288-(E-Mail Removed)...
>
> >I see. While you may be correct in your guess, I think you're still making
> >a big assumption.
>
> 20+ years of supporting end users? I'll stick with my guess until proven
> wrong.

My guess is the OP is using Access as if it is Excel. He/she is confusing
"columns" with "fields" and probably has an un-normalized table structure
which creates a need to sum across fields rather than across records. (25
years of supporting end users)

--
Duane Hookom
MS Access MVP
--

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
news:7980500C-90EE-4B76-B176-(E-Mail Removed)...
> Perhaps you've been listening to your son, Bart, too much. I think your
> daughter, Lisa, might have wiser advice for you.
>
> By the way, you're not the only one who has 20+ years supporting end
> users.
>
>
> Tom
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
> "Homer J Simpson" wrote:
>
>>
>> "Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message
>> news:135F55C9-1283-4C5A-B288-(E-Mail Removed)...
>>
>> >I see. While you may be correct in your guess, I think you're still
>> >making
>> >a big assumption.
>>
>> 20+ years of supporting end users? I'll stick with my guess until proven
>> wrong.

"Duane Hookom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> My guess is the OP is using Access as if it is Excel. He/she is confusing
> "columns" with "fields" and probably has an un-normalized table structure
> which creates a need to sum across fields rather than across records. (25
> years of supporting end users)

IMO too many posters read the name of this group as Microsoft (public
access) instead of Microsoft Access (public). So they think that this is the
first (or last) place to ask anything Microsoft or PC related. How many even
know that Access is the name of the DB product?