Re: Multiple Table Query



Could you give us an example of the sort of output that you want to see?


"Nixxie" <Nixxie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:230A52C7-6DF8-478B-B7D5-0B3F482F2844@xxxxxxxxxxxxxxxx
I run a database that keeps various sorts of records, one Common field
between them all is the 'Parish' field.
What I need is to run some type of query between all of the tables with
this
field so that I can see what information of every type we have for this
'Parish'. Rather than opening each table in the same database, I need a
query
that will display the record number for each entry it displays, to keep it
as
simple as possible to run.
I have tried it a number of ways but so far had no luck and need to have
it
running as soon as possible.
Any help would be brilliant.


.



Relevant Pages

  • Re: Multiple Table Query
    ... Do all the tables have the exact same number of ... between them all is the 'Parish' field. ... What I need is to run some type of query between all of the tables with ... I have tried it a number of ways but so far had no luck and need to have ...
    (microsoft.public.access.queries)
  • Re: If you think mfw can get out of hand...
    ... dear old Johnny Williams, some sort of a lawyer, late of this parish!! ... Does the British medical system provide drugs for obsessions like ...
    (misc.fitness.weights)