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
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
:
:
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.