Re: Help with query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Spencer (kspencer_at_takempis.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 17:21:33 -0400

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
"Paul Milner" <anonymous@discussions.microsoft.com> wrote in message
news:0fdf01c49c32$4ead3ad0$a301280a@phx.gbl...
> 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

Relevant Pages

  • Re: Queries when the "one" table is used several times
    ... When you create a query into this table, the problem will be with the joins. ... When you add the Cities table, Access might produce 5 lines between Cities ... there is no city. ... By making outer joins like this, the query returns all records from your ...
    (microsoft.public.access.queries)
  • adding a new record in a form using a VBA procedure
    ... table contains potential sales leads. ... specifies which city the lead is in. ... The list of allowable cities is stored ... The form's data source is a query of the sales leads table. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reports with a grouped field.
    ... Create a query that lists all the cities. ... SELECT DISTINCT City FROM Clients ... Create a report using that query. ...
    (microsoft.public.access.reports)
  • Re: Counting instances of a string in a memo field
    ... SELECT "AuckLand" as City, CountAS CountOfPostal ... FROM declearer ... FROM Declearer INNER JOIN Cities ... You obviously cannot build this query using the query grid. ...
    (microsoft.public.access.queries)
  • Re: Need to tune a table for performance gains
    ... as long as you know what city a person is in. ... query to find out how many records that is. ... in when you are filtering on several columns. ... We create two _Mini ...
    (comp.databases.ms-sqlserver)