Word :    Username :           
 

Archived from groups: microsoft.public.windowsxp.general (More info?)

 

Hi,
I know this is in the wrong section, but i was hopping someone could help me
out.

Is there any way of using a basic addition formula in Microsoft Access?
If so, could you please show how.

Thanks

Sponsored Links
Register or log in to remove.

Archived from groups: microsoft.public.windowsxp.general (More info?)

 

You know how queries work?

---------------------------
Table 1
---------------------------
Field 1 | Field 2

---------------------------

---------------------------
selQueryAddFields
---------------------------
SELECT [Table 1].[Field 1] + [Table 1].[Field 1] AS [AddFields]
FROM [Table 1]
---------------------------

---------------------------
selQueryAddRows
---------------------------
SELECT SUM([Table 1].[Field 1] ) AS [AddRows]
FROM [Table 1]
---------------------------

Anymore complex just head off to
microsoft.public.access.queries
microsoft.public.access

Just be a bit more proactive in your quest for answers.

- Winux P.

"buddy" <buddy@discussions.microsoft.com> wrote in message
news:B219DD65-AA05-4842-8EAE-D5580D604C0A@microsoft.com...
> Hi,
> I know this is in the wrong section, but i was hopping someone could help
> me
> out.
>
> Is there any way of using a basic addition formula in Microsoft Access?
> If so, could you please show how.
>
> Thanks

Reply to Anonymous

Archived from groups: microsoft.public.windowsxp.general (More info?)

 

Or, if you are in a form you can add another text field and
set the value to "=[field1] + [field2]", without the quotes

"Winux P" <winuxp@msnews.grp> wrote in message
news:u80%23Ps9lFHA.3448@TK2MSFTNGP12.phx.gbl...
:
: You know how queries work?
:
: ---------------------------
: Table 1
: ---------------------------
: Field 1 | Field 2
:
: ---------------------------
:
: ---------------------------
: selQueryAddFields
: ---------------------------
: SELECT [Table 1].[Field 1] + [Table 1].[Field 1] AS
[AddFields]
: FROM [Table 1]
: ---------------------------
:
: ---------------------------
: selQueryAddRows
: ---------------------------
: SELECT SUM([Table 1].[Field 1] ) AS [AddRows]
: FROM [Table 1]
: ---------------------------
:
: Anymore complex just head off to
: microsoft.public.access.queries
: microsoft.public.access
:
: Just be a bit more proactive in your quest for answers.
:
: - Winux P.
:
: "buddy" <buddy@discussions.microsoft.com> wrote in message
: news:B219DD65-AA05-4842-8EAE-D5580D604C0A@microsoft.com...
: > Hi,
: > I know this is in the wrong section, but i was hopping
someone could help
: > me
: > out.
: >
: > Is there any way of using a basic addition formula in
Microsoft Access?
: > If so, could you please show how.
: >
: > Thanks
:
:

Reply to Anonymous
Tom's Hardware > Forum > Windows XP > Windows XP General Discussion > Microsoft Office
Go to:

There are 1092 identified and unidentified users. To see the list of identified users, Click here.

Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel
Sponsored links
  • Ask the community now
  • Publish
Ad
They won a badge
Join us in greeting them