Re: Multiple PHone Numbers

On Jun 10, 8:46 am, Propoflady <cha...@xxxxxxxxxxxxx> wrote:
My contacts can have as many as five or six phone numbers - is it
possible to make a query that puts the name, and each phone number
after it on the same line - for this reason I have two tables - client
and phone linked by client id

right now I get
contact a - phone number 1
contact a - phone number 2

I would like
contact a - phone number1, phone number 2

what is the structure of your data, how many tables
.

Relevant Pages

  • Re: How can I assign the result of dateadd to a variable ?
    ... The reason why I used text is because the length of the packet_data varies, ... > What bugged me more was the difference in execution time between the query ... > using the text in row option. ... > there will be no rows returned to the client, ...
    (microsoft.public.sqlserver.programming)
  • Re: Multiple PHone Numbers
    ... Propoflady wrote in ... possible to make a query that puts the name, ... client and phone linked by client id ...
    (comp.databases.ms-access)
  • Multiple PHone Numbers
    ... possible to make a query that puts the name, ... after it on the same line - for this reason I have two tables - client ... contact a - phone number1, ...
    (comp.databases.ms-access)
  • Re: Multiple PHone Numbers
    ... possible to make a query that puts the name, ... after it on the same line - for this reason I have two tables - client ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Multiple PHone Numbers
    ... possible to make a query that puts the name, ... after it on the same line - for this reason I have two tables - client ... Put a txt box in your report. ...
    (comp.databases.ms-access)