[mso] Re: Access Ref in Query or Excel
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 10:45:46 -0400
I managed to answer my own question by writing a select statement in
SQL.
table1 only has the sum of dollar values extracted via a make table
query
table2 has the sum of dollar values for 2004 and 2005, also from a make
table query
my third and final make table query for this exercise is an SQL select
statement that performs the subtraction
This result is then referenced from a field in my Excel worksheet via
Data/Import External Data...
table1
ParticipantTotals
$13,000
table2
2004=$5,000
2005=$7,500
result table sql
SELECT ([table1]![PaticipantTotals]-[table2]![2005]) AS
totAnnParticipants
FROM table1, table2;
actual result
$5,500
_____
From: Glenda Wells
Sent: Tuesday, May 10, 2005 04:39 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: Access Ref in Query or Excel
In an Access query, I need to perform subtraction between two
separate tables and can't figure out the reference.
I tried this
([table1]![totalField]-[table2]![totalField2])
Actually, if I could reference these two table totals from Excel
and do the math there, that would be even better.
Any thoughts appreciated. /g
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
