Kilometres Query

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved
I have 3 columns the 3rd columns is Kilometres
I would like to do a Query to get Kilometres
How would I go about this please.

City Depot To Exmouth 5.9
To Exmouth Mairangi Bay 11.0
ASB Ponsonby Britomart Centre 1.5
Auckland Browns Bay 20.0
Auckland Newmarket 2.0
Auckland Three Kings 5.4
Avondale Symonds St 14.4
Avondale Symonds Street 11.2

Thankyou.
 
Hello from Steved
I have 3 columns the 3rd columns is Kilometres
I would like to do a Query to get Kilometres
How would I go about this please.

City Depot To Exmouth 5.9
To Exmouth Mairangi Bay 11.0
ASB Ponsonby Britomart Centre 1.5
Auckland Browns Bay 20.0
Auckland Newmarket 2.0
Auckland Three Kings 5.4
Avondale Symonds St 14.4
Avondale Symonds Street 11.2

Thankyou.
Click to expand...

You *have* Kilometers. They're right there in the third field. What do
you want to "get"?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hello From Steved

John I want to set up a query as I've over five hundred

I want to put it in a database Ask a query as an example
given below "Auckland", "Browns Bay" run the query and
get 20.0

Thankyou.
 
Steve just do a simple query on those three fields and create two parameters
where you will supply to to and from and get the KM as the result.
 
Hello From Steved

John I want to set up a query as I've over five hundred

I want to put it in a database Ask a query as an example
given below "Auckland", "Browns Bay" run the query and
get 20.0
Click to expand...

Create a new Query based on the table.

On the Criteria line under the first field put

[Enter starting point:]

and under the second field put

[Enter destination:]

If you then open the query you'll get prompted for two cities and you
will see the row with the kilometers.

You can get much fancier without a great deal of effort, though - for
instance, having a form which lets you pick the cities from drop-down
lists and displays the distance. Post back if you're interested.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hello From Steved

I've bought myself learning Access CD's. You have
given me a starting point. I will go ahead and create
the table and if I need assistance I will post Back.

Thankyou
-----Original Message-----
Hello From Steved

John I want to set up a query as I've over five hundred

I want to put it in a database Ask a query as an example
given below "Auckland", "Browns Bay" run the query and
get 20.0
Click to expand...

Create a new Query based on the table.

On the Criteria line under the first field put

[Enter starting point:]

and under the second field put

[Enter destination:]

If you then open the query you'll get prompted for two cities and you
will see the row with the kilometers.

You can get much fancier without a great deal of effort, though - for
instance, having a form which lets you pick the cities from drop-down
lists and displays the distance. Post back if you're interested.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.
Click to expand...
 
Hello Fakhruddin from Steved

Thankyou. I just started to learn Access. Hence both of
you have giving me a starting point.

Thanks again.
 
Back
Top