2 random fields from a single field?

[efandango]

I want to display a set of 2 random fields from a single address field. How
can I do this?

my fields are:

Point_ID (autonumber)
Run_point_address.

I want to display the results like this

Point_ID_1 Run_point_address Point_ID_2 Run_point_address
2143 Main Street 232 South Street
983 Middle street 1823 Long Road
354235 West Street 7920 Broadway


I tried this SQL, but it just asks me for Point_ID1.

SELECT tbl_Points.Run_point_Address, tbl_Points.[Point_ID] AS Point_ID1,
tbl_Points.[Point_ID] AS Point_ID2
FROM tbl_Points
ORDER BY Rnd([Point_ID1]), Rnd([Point_ID2]);


I can't work out where I am going wrong, can someone point me in the right
direction?

 

[KARL DEWEY]

I do not know what you are trying to do but you are confusing Access.
You have --
tbl_Points.[Point_ID] ----- one dash, no number
Point_ID1 ----- one dash with number
Point_ID_1 ---- two dashes with number
Rnd([Point_ID1]) -- one dash with number

What is you purpose?