By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,284 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,284 IT Pros & Developers. It's quick & easy.

Selecting Data to get a value

P: n/a
I am using Access 2002. I would like to track mileage between
buildings. I work for a school district so for Example I went from the
High School to my Office - 3.2 Miles away. Can I set up a big table
with all the To locations and all the From Locations and their miles
apart and then in a form be able to select a To Location and a From
Location in two different dropdown boxes and have the miles show up
the the field miles? I also want to have the miles add up to print
out on a report. That is my big obstical. This one database will be
used with multiple staff members but I have the sorting all figured
out I just need to know how to "link" the two tables to automatically
give me data. PS I don't know VB or how to use Modules at all. Can
someone help me?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sean, You need these tables:

TblStaff
StaffID
FirstName
LastName
etc

TblBuilding
BuildingID
BuildingName

TblMileage
MileageID
FromBuildIngID
ToBuildingID
Miles

TblTravel
TravelID
StaffID
TravelDate
TravelStartTime
TravekEndTime
MileAgeID
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Sean" <sf******@salem.k12.nh.us> wrote in message
news:f6**************************@posting.google.c om...
I am using Access 2002. I would like to track mileage between
buildings. I work for a school district so for Example I went from the
High School to my Office - 3.2 Miles away. Can I set up a big table
with all the To locations and all the From Locations and their miles
apart and then in a form be able to select a To Location and a From
Location in two different dropdown boxes and have the miles show up
the the field miles? I also want to have the miles add up to print
out on a report. That is my big obstical. This one database will be
used with multiple staff members but I have the sorting all figured
out I just need to know how to "link" the two tables to automatically
give me data. PS I don't know VB or how to use Modules at all. Can
someone help me?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.