Help with query

[Paul Milner]

Hi
In a results query how can you take one field and add it
to another field for example
I have a field in a database called geographical location
which lists countries and a field called uk cities
If in the search the person selects UK and then a city
from uk cities how can I input the uk city into the
goegraghical field so the output would read something
like
UK,London

 

[Kevin Spencer]

Probably at your skill level it would be best to put it into the query. Try
something like:

SELECT (country & ", " & city) As loc FROM myTable

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living