Query look up!

[Presto731]

I have a table that has mileage between two points. Each point has a unique id#

in my query I want to be able to type in the id for point 1 and then type the id for point 2 and get the mileage. I know by simply putting [enter] in the criteria field for point one i can look up that one, how do make it so you enter both id#'s and get the mileage for those two points.

any thoughts?

[damonreid]

Milage has to be from somewhere by default. Are they both from the same location and you want to find the difference?

[Presto731]

Milage has to be from somewhere by default. Are they both from the same location and you want to find the difference?

the table with the data looks like this:

point 1 point 2 mileage between them
xxx yyy 1234
yyy zzz 5678
zzz xxx 9101
etc...............................

there are about 1200 total

both point colums have the same info. so point xxx has mileage to all but xxx, yyy has mileage to all but yyy, so on............

my goal is to enter in a point and instead of seeing mileage to all the other s i want to enter the second point and just see that.

I hope i';m explaining this correctly.

[JKing]

Is this what you're looking for?

Select point1, point2, mileage
FROM tblPoints
WHERE point1 = [Enter Point1] and point2 = [Enter Point2]
 

[Presto731]

lol, thats the long and short of it

[JKing]

Well that would provide criteria for both points. Prompting the user to enter point1 followed by point2 and bringing up only that specific record. What more would you like?

[Presto731]

where exactly do i type that code

[JKing]

Select point1, point2, mileage
FROM tblPoints
WHERE point1 = [Enter Point1] and point2 = [Enter Point2]
 

Start a new query. Then instead of design view or datasheet view go into SQL view. This is where you would put the SQL I posted. Just make sure you change the field names to reflect your actual field names. Same goes for the table name.

point1 = Point 1 field name
point2 = Point 2 field name
mileage = mileage field name
tblPoints = table the data is stored in

[Presto731]

Start a new query. Then instead of design view or datasheet view go into SQL view. This is where you would put the SQL I posted. Just make sure you change the field names to reflect your actual field names. Same goes for the table name.

point1 = Point 1 field name
point2 = Point 2 field name
mileage = mileage field name
tblPoints = table the data is stored in

will do, thank you for your help

[JKing]

If you run into any problems let me know.

Good Luck

Jking