Help with query

  • Thread starter Thread starter Paul Milner
  • Start date Start date
P

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
 
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
 
Back
Top