[mso] Re: Excel - Access Inquiry
- From: "Dave Sharpe" <DaveSharpe2@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 11 Jun 2004 23:56:17 -0400
Robert
For a formula, go to the bottom of
http://www.melissadata.com/zd.html
and select "download the manual"
Go to the exact solution on page 16
of 22.
----- Original Message -----
From: "Robert Carneal" <bookofficeworker@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, June 11, 2004 8:42 PM
Subject: [mso] Excel - Access Inquiry
I have a file of towns/cities, counties, states, longitude, latitude,
roughly 97,000 records deep.
Right now, I have it broken about in half, roughly 48,500 on each sheet
over two sheets.
I wanted to make this an access application, but I am beginning to wonder
if I can. Let's say I pick:
Town: Appleton
County: Granning
State: Texas
I have written a little routine that allows me to enter a number, say 75,
and it will go through both lists, looking for courthouses within 75 miles
of Appleton, Granning, Texas. This means I am using Lat/Long
formulas. (For those wanting to know why I do this, it narrows down the
courthouses I
Will Access give me the ability to do that? And if the answer is yes, can
someone please point me to an example of formulas in Access? And please do
not let my inquiry start an Access/Excel fight. they are interesting to
read, but...<g>
Thank you.
Robert
*************************************************************
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:
