[mso] Re: Database or Spreadsheet :VSMail mx3

  • From: James LaBorde <jlaborde@xxxxxxxxx>
  • To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
  • Date: Tue, 8 Jun 2004 13:37:25 -0700

Linda,

You can use the expression builder. It contains the same prompts as your
wizard.  The only thing you do is enter field names (or values) instead of
cell references.  While you need to do a little to get to it, (not a lot) it
isn't much different than the Excel wizard.  One of the best things is, I
can add a column to my query window without affecting my formula.  Depending
on whether or not you use absolute references in Excel, adding a column or
row, could cause problems.

James



-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, June 08, 2004 1:36 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Database or Spreadsheet :VSMail mx3


Right...so without the wizard, you need to understand the math behind the
formula...that is my whole point.  Excel's Paste Function feature does not
require that you have ANY knowledge of the math behind the formula....that's
what Excel does...You plug in the numbers and it does the math!

If Access has a wizard like this, PLEASE PLEASE PLEASE tell me where it is!


Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
it came from me, it did NOT!

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Tuesday, June 08, 2004 4:24 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Database or Spreadsheet :VSMail mx4

Linda,

Access does have the same Pmt function, with the same parameters.  The only
thing you lack is the wizard to put it in.  I am sure that is around too if
you really wanted it.

James



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