Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Can This be Done!

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

Tags:
  1. Bob

    Bob
    Expand Collapse
    Guest

    I have 3 Query's

    Query1
    OwnerID (Number)
    OwnerLast Name (Text)
    OwnerFirst Name(Text)

    Query2
    HorseID (Number)
    HorseName (Text)

    Query3
    OwnerID (Number)
    HorseID (Number)
    OwnerPercent (Number%)

    What I want is to have a query that has OwnerLast Name,OwnerFirst Name,
    HorseName, Owner Percenatge
    Can this be Done!
    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News International Sikh Award For Man Who Has Been Taking Care Of Abandoned Patients For 20 Breaking News Sep 26, 2016
    Sikhi Bibi Prakash Kaur: Rescuing India's Abandoned Girls Sikh Sikhi Sikhism Jul 18, 2016
    Sikhi Unsung Heroes - Gurmeet Singh, A Messiah For The Abandoned Sick Sikh Sikhi Sikhism Feb 15, 2016
    Kaum Sikh Indonesia - Part 1 Sikh Sikhi Sikhism Jan 9, 2016
    Sunday night, nearly done Blogs Oct 17, 2015

  3. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Bob

    No problem! Create a new query and add these three queries (or are they
    actually tables) into the design area. Make sure that there are joins
    between the two OwnerID fields and the two HorseID fields. Then simply add
    the four fields you want by dragging them down onto the query design grid.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Bob" <xxx@xx.xx> wrote in message news:e89mon$dnf$1@lust.ihug.co.nz...
    >
    >
    > I have 3 Query's
    >
    > Query1
    > OwnerID (Number)
    > OwnerLast Name (Text)
    > OwnerFirst Name(Text)
    >
    > Query2
    > HorseID (Number)
    > HorseName (Text)
    >
    > Query3
    > OwnerID (Number)
    > HorseID (Number)
    > OwnerPercent (Number%)
    >
    > What I want is to have a query that has OwnerLast Name,OwnerFirst Name,
    > HorseName, Owner Percenatge
    > Can this be Done!
    > Thanks in advance.........Bob Vance
    >
     
  4. Bob

    Bob
    Expand Collapse
    Guest

    Graham , join which ones together
    I have 3 Query tables in 1 table now!
    Thanks Bob
    "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    > Hi Bob
    >
    > No problem! Create a new query and add these three queries (or are they
    > actually tables) into the design area. Make sure that there are joins
    > between the two OwnerID fields and the two HorseID fields. Then simply
    > add the four fields you want by dragging them down onto the query design
    > grid.
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e89mon$dnf$1@lust.ihug.co.nz...
    >>
    >>
    >> I have 3 Query's
    >>
    >> Query1
    >> OwnerID (Number)
    >> OwnerLast Name (Text)
    >> OwnerFirst Name(Text)
    >>
    >> Query2
    >> HorseID (Number)
    >> HorseName (Text)
    >>
    >> Query3
    >> OwnerID (Number)
    >> HorseID (Number)
    >> OwnerPercent (Number%)
    >>
    >> What I want is to have a query that has OwnerLast Name,OwnerFirst Name,
    >> HorseName, Owner Percenatge
    >> Can this be Done!
    >> Thanks in advance.........Bob Vance
    >>

    >
    >
     
  5. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Bob

    The related fields in your tables should be joined in the query. Have you
    ever created a multi-table query before? Have a look in the Northwind
    sample database - there are lots of examples.

    If you are still having trouble, post back some details of your table
    designs (table names, field names and types).
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Bob" <xxx@xx.xx> wrote in message news:e89q8c$k3k$1@lust.ihug.co.nz...
    > Graham , join which ones together
    > I have 3 Query tables in 1 table now!
    > Thanks Bob
    > "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    > news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >> Hi Bob
    >>
    >> No problem! Create a new query and add these three queries (or are they
    >> actually tables) into the design area. Make sure that there are joins
    >> between the two OwnerID fields and the two HorseID fields. Then simply
    >> add the four fields you want by dragging them down onto the query design
    >> grid.
    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>
    >>>
    >>> I have 3 Query's
    >>>
    >>> Query1
    >>> OwnerID (Number)
    >>> OwnerLast Name (Text)
    >>> OwnerFirst Name(Text)
    >>>
    >>> Query2
    >>> HorseID (Number)
    >>> HorseName (Text)
    >>>
    >>> Query3
    >>> OwnerID (Number)
    >>> HorseID (Number)
    >>> OwnerPercent (Number%)
    >>>
    >>> What I want is to have a query that has OwnerLast Name,OwnerFirst Name,
    >>> HorseName, Owner Percenatge
    >>> Can this be Done!
    >>> Thanks in advance.........Bob Vance
    >>>

    >>
    >>

    >
    >
     
  6. Bob

    Bob
    Expand Collapse
    Guest

    Looked at Northwind, they seem to get certain field names darker and there
    link has 00 and 1 on the line
    Is that how they should be linked not just the thin line
    Thanks bob

    "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    > Hi Bob
    >
    > The related fields in your tables should be joined in the query. Have you
    > ever created a multi-table query before? Have a look in the Northwind
    > sample database - there are lots of examples.
    >
    > If you are still having trouble, post back some details of your table
    > designs (table names, field names and types).
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e89q8c$k3k$1@lust.ihug.co.nz...
    >> Graham , join which ones together
    >> I have 3 Query tables in 1 table now!
    >> Thanks Bob
    >> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>> Hi Bob
    >>>
    >>> No problem! Create a new query and add these three queries (or are they
    >>> actually tables) into the design area. Make sure that there are joins
    >>> between the two OwnerID fields and the two HorseID fields. Then simply
    >>> add the four fields you want by dragging them down onto the query design
    >>> grid.
    >>> --
    >>> Good Luck!
    >>>
    >>> Graham Mandeno [Access MVP]
    >>> Auckland, New Zealand
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>
    >>>>
    >>>> I have 3 Query's
    >>>>
    >>>> Query1
    >>>> OwnerID (Number)
    >>>> OwnerLast Name (Text)
    >>>> OwnerFirst Name(Text)
    >>>>
    >>>> Query2
    >>>> HorseID (Number)
    >>>> HorseName (Text)
    >>>>
    >>>> Query3
    >>>> OwnerID (Number)
    >>>> HorseID (Number)
    >>>> OwnerPercent (Number%)
    >>>>
    >>>> What I want is to have a query that has OwnerLast Name,OwnerFirst Name,
    >>>> HorseName, Owner Percenatge
    >>>> Can this be Done!
    >>>> Thanks in advance.........Bob Vance
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  7. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Bob

    It seems you are missing a few of the basics here :-S

    The "00" you see in Northwind is actually an infinity sign (an "8" on its
    side). It represents the "many" side of a one-to-many relationship (the "1"
    represents the "one" side).

    The bold fieldnames you see are the tables' primary keys. Do you not have
    primary keys, or other indexes, defined in your tables? Every one of your
    tables (with perhaps the occasional exception) ought to have a primary key.
    This is the means of uniquely identifying a record - a horse or an owner,
    for example. I had assumed that your fields HorseID and OwnerID were the
    primary keys in those respective tables.

    May I suggest again that you post back some details of your table designs
    (table names, field names and types).

    If you're desperate, you'll find me in the Auckland phone book.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Bob" <xxx@xx.xx> wrote in message news:e89sju$oar$1@lust.ihug.co.nz...
    > Looked at Northwind, they seem to get certain field names darker and there
    > link has 00 and 1 on the line
    > Is that how they should be linked not just the thin line
    > Thanks bob
    >
    > "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    > news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >> Hi Bob
    >>
    >> The related fields in your tables should be joined in the query. Have
    >> you ever created a multi-table query before? Have a look in the
    >> Northwind sample database - there are lots of examples.
    >>
    >> If you are still having trouble, post back some details of your table
    >> designs (table names, field names and types).
    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>> Graham , join which ones together
    >>> I have 3 Query tables in 1 table now!
    >>> Thanks Bob
    >>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>> Hi Bob
    >>>>
    >>>> No problem! Create a new query and add these three queries (or are
    >>>> they actually tables) into the design area. Make sure that there are
    >>>> joins between the two OwnerID fields and the two HorseID fields. Then
    >>>> simply add the four fields you want by dragging them down onto the
    >>>> query design grid.
    >>>> --
    >>>> Good Luck!
    >>>>
    >>>> Graham Mandeno [Access MVP]
    >>>> Auckland, New Zealand
    >>>>
    >>>> "Bob" <xxx@xx.xx> wrote in message news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>
    >>>>>
    >>>>> I have 3 Query's
    >>>>>
    >>>>> Query1
    >>>>> OwnerID (Number)
    >>>>> OwnerLast Name (Text)
    >>>>> OwnerFirst Name(Text)
    >>>>>
    >>>>> Query2
    >>>>> HorseID (Number)
    >>>>> HorseName (Text)
    >>>>>
    >>>>> Query3
    >>>>> OwnerID (Number)
    >>>>> HorseID (Number)
    >>>>> OwnerPercent (Number%)
    >>>>>
    >>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>> Name, HorseName, Owner Percenatge
    >>>>> Can this be Done!
    >>>>> Thanks in advance.........Bob Vance
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  8. Bob

    Bob
    Expand Collapse
    Guest

    UNBELIEVABLE I did it , I put the 3 Queries together then put lines between
    HorseID to HorseID, OwnerID to OwnerID and that sent my records from 18,000
    to 39 Indivual Owners with there horses, I don't believe I did it ,thanks
    for your help.......Bob :)
    "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    news:O$Ue3munGHA.4728@TK2MSFTNGP03.phx.gbl...
    > Hi Bob
    >
    > It seems you are missing a few of the basics here :-S
    >
    > The "00" you see in Northwind is actually an infinity sign (an "8" on its
    > side). It represents the "many" side of a one-to-many relationship (the
    > "1" represents the "one" side).
    >
    > The bold fieldnames you see are the tables' primary keys. Do you not have
    > primary keys, or other indexes, defined in your tables? Every one of your
    > tables (with perhaps the occasional exception) ought to have a primary
    > key. This is the means of uniquely identifying a record - a horse or an
    > owner, for example. I had assumed that your fields HorseID and OwnerID
    > were the primary keys in those respective tables.
    >
    > May I suggest again that you post back some details of your table designs
    > (table names, field names and types).
    >
    > If you're desperate, you'll find me in the Auckland phone book.
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e89sju$oar$1@lust.ihug.co.nz...
    >> Looked at Northwind, they seem to get certain field names darker and
    >> there link has 00 and 1 on the line
    >> Is that how they should be linked not just the thin line
    >> Thanks bob
    >>
    >> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >> news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >>> Hi Bob
    >>>
    >>> The related fields in your tables should be joined in the query. Have
    >>> you ever created a multi-table query before? Have a look in the
    >>> Northwind sample database - there are lots of examples.
    >>>
    >>> If you are still having trouble, post back some details of your table
    >>> designs (table names, field names and types).
    >>> --
    >>> Good Luck!
    >>>
    >>> Graham Mandeno [Access MVP]
    >>> Auckland, New Zealand
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>>> Graham , join which ones together
    >>>> I have 3 Query tables in 1 table now!
    >>>> Thanks Bob
    >>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>>> Hi Bob
    >>>>>
    >>>>> No problem! Create a new query and add these three queries (or are
    >>>>> they actually tables) into the design area. Make sure that there are
    >>>>> joins between the two OwnerID fields and the two HorseID fields. Then
    >>>>> simply add the four fields you want by dragging them down onto the
    >>>>> query design grid.
    >>>>> --
    >>>>> Good Luck!
    >>>>>
    >>>>> Graham Mandeno [Access MVP]
    >>>>> Auckland, New Zealand
    >>>>>
    >>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>> news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>>
    >>>>>>
    >>>>>> I have 3 Query's
    >>>>>>
    >>>>>> Query1
    >>>>>> OwnerID (Number)
    >>>>>> OwnerLast Name (Text)
    >>>>>> OwnerFirst Name(Text)
    >>>>>>
    >>>>>> Query2
    >>>>>> HorseID (Number)
    >>>>>> HorseName (Text)
    >>>>>>
    >>>>>> Query3
    >>>>>> OwnerID (Number)
    >>>>>> HorseID (Number)
    >>>>>> OwnerPercent (Number%)
    >>>>>>
    >>>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>>> Name, HorseName, Owner Percenatge
    >>>>>> Can this be Done!
    >>>>>> Thanks in advance.........Bob Vance
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  9. Bob

    Bob
    Expand Collapse
    Guest

    Graham I now have 3 columns in my dropdown list can I make just the 3rd
    Column right align and the first 2 left align......Thanks Bob

    "Bob" <xxx@xx.xx> wrote in message news:e8c9jb$42m$1@lust.ihug.co.nz...
    > UNBELIEVABLE I did it , I put the 3 Queries together then put lines
    > between HorseID to HorseID, OwnerID to OwnerID and that sent my records
    > from 18,000 to 39 Indivual Owners with there horses, I don't believe I did
    > it ,thanks for your help.......Bob :)
    > "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    > news:O$Ue3munGHA.4728@TK2MSFTNGP03.phx.gbl...
    >> Hi Bob
    >>
    >> It seems you are missing a few of the basics here :-S
    >>
    >> The "00" you see in Northwind is actually an infinity sign (an "8" on its
    >> side). It represents the "many" side of a one-to-many relationship (the
    >> "1" represents the "one" side).
    >>
    >> The bold fieldnames you see are the tables' primary keys. Do you not
    >> have primary keys, or other indexes, defined in your tables? Every one
    >> of your tables (with perhaps the occasional exception) ought to have a
    >> primary key. This is the means of uniquely identifying a record - a horse
    >> or an owner, for example. I had assumed that your fields HorseID and
    >> OwnerID were the primary keys in those respective tables.
    >>
    >> May I suggest again that you post back some details of your table designs
    >> (table names, field names and types).
    >>
    >> If you're desperate, you'll find me in the Auckland phone book.
    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e89sju$oar$1@lust.ihug.co.nz...
    >>> Looked at Northwind, they seem to get certain field names darker and
    >>> there link has 00 and 1 on the line
    >>> Is that how they should be linked not just the thin line
    >>> Thanks bob
    >>>
    >>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>> news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >>>> Hi Bob
    >>>>
    >>>> The related fields in your tables should be joined in the query. Have
    >>>> you ever created a multi-table query before? Have a look in the
    >>>> Northwind sample database - there are lots of examples.
    >>>>
    >>>> If you are still having trouble, post back some details of your table
    >>>> designs (table names, field names and types).
    >>>> --
    >>>> Good Luck!
    >>>>
    >>>> Graham Mandeno [Access MVP]
    >>>> Auckland, New Zealand
    >>>>
    >>>> "Bob" <xxx@xx.xx> wrote in message news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>>>> Graham , join which ones together
    >>>>> I have 3 Query tables in 1 table now!
    >>>>> Thanks Bob
    >>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>>>> Hi Bob
    >>>>>>
    >>>>>> No problem! Create a new query and add these three queries (or are
    >>>>>> they actually tables) into the design area. Make sure that there are
    >>>>>> joins between the two OwnerID fields and the two HorseID fields.
    >>>>>> Then simply add the four fields you want by dragging them down onto
    >>>>>> the query design grid.
    >>>>>> --
    >>>>>> Good Luck!
    >>>>>>
    >>>>>> Graham Mandeno [Access MVP]
    >>>>>> Auckland, New Zealand
    >>>>>>
    >>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>> news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>>>
    >>>>>>>
    >>>>>>> I have 3 Query's
    >>>>>>>
    >>>>>>> Query1
    >>>>>>> OwnerID (Number)
    >>>>>>> OwnerLast Name (Text)
    >>>>>>> OwnerFirst Name(Text)
    >>>>>>>
    >>>>>>> Query2
    >>>>>>> HorseID (Number)
    >>>>>>> HorseName (Text)
    >>>>>>>
    >>>>>>> Query3
    >>>>>>> OwnerID (Number)
    >>>>>>> HorseID (Number)
    >>>>>>> OwnerPercent (Number%)
    >>>>>>>
    >>>>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>>>> Name, HorseName, Owner Percenatge
    >>>>>>> Can this be Done!
    >>>>>>> Thanks in advance.........Bob Vance
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  10. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Hi Bob

    Well done getting the query working :)

    No, sorry, you have no control over the horizontal alignment of columns in a
    listbox or combobox.

    PLEASE PLEASE PLEASE, for the sake of your future sanity, make sure that you
    add proper indexes (primary keys at the very least!) into your tables, and
    set up proper relationships to ensure referential integrity between your
    tables.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Bob" <xxx@xx.xx> wrote in message news:e8cam0$5uf$1@lust.ihug.co.nz...
    > Graham I now have 3 columns in my dropdown list can I make just the 3rd
    > Column right align and the first 2 left align......Thanks Bob
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e8c9jb$42m$1@lust.ihug.co.nz...
    >> UNBELIEVABLE I did it , I put the 3 Queries together then put lines
    >> between HorseID to HorseID, OwnerID to OwnerID and that sent my records
    >> from 18,000 to 39 Indivual Owners with there horses, I don't believe I
    >> did it ,thanks for your help.......Bob :)
    >> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >> news:O$Ue3munGHA.4728@TK2MSFTNGP03.phx.gbl...
    >>> Hi Bob
    >>>
    >>> It seems you are missing a few of the basics here :-S
    >>>
    >>> The "00" you see in Northwind is actually an infinity sign (an "8" on
    >>> its side). It represents the "many" side of a one-to-many relationship
    >>> (the "1" represents the "one" side).
    >>>
    >>> The bold fieldnames you see are the tables' primary keys. Do you not
    >>> have primary keys, or other indexes, defined in your tables? Every one
    >>> of your tables (with perhaps the occasional exception) ought to have a
    >>> primary key. This is the means of uniquely identifying a record - a
    >>> horse or an owner, for example. I had assumed that your fields HorseID
    >>> and OwnerID were the primary keys in those respective tables.
    >>>
    >>> May I suggest again that you post back some details of your table
    >>> designs (table names, field names and types).
    >>>
    >>> If you're desperate, you'll find me in the Auckland phone book.
    >>> --
    >>> Good Luck!
    >>>
    >>> Graham Mandeno [Access MVP]
    >>> Auckland, New Zealand
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e89sju$oar$1@lust.ihug.co.nz...
    >>>> Looked at Northwind, they seem to get certain field names darker and
    >>>> there link has 00 and 1 on the line
    >>>> Is that how they should be linked not just the thin line
    >>>> Thanks bob
    >>>>
    >>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>> news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >>>>> Hi Bob
    >>>>>
    >>>>> The related fields in your tables should be joined in the query. Have
    >>>>> you ever created a multi-table query before? Have a look in the
    >>>>> Northwind sample database - there are lots of examples.
    >>>>>
    >>>>> If you are still having trouble, post back some details of your table
    >>>>> designs (table names, field names and types).
    >>>>> --
    >>>>> Good Luck!
    >>>>>
    >>>>> Graham Mandeno [Access MVP]
    >>>>> Auckland, New Zealand
    >>>>>
    >>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>> news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>>>>> Graham , join which ones together
    >>>>>> I have 3 Query tables in 1 table now!
    >>>>>> Thanks Bob
    >>>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>>>>> Hi Bob
    >>>>>>>
    >>>>>>> No problem! Create a new query and add these three queries (or are
    >>>>>>> they actually tables) into the design area. Make sure that there
    >>>>>>> are joins between the two OwnerID fields and the two HorseID fields.
    >>>>>>> Then simply add the four fields you want by dragging them down onto
    >>>>>>> the query design grid.
    >>>>>>> --
    >>>>>>> Good Luck!
    >>>>>>>
    >>>>>>> Graham Mandeno [Access MVP]
    >>>>>>> Auckland, New Zealand
    >>>>>>>
    >>>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>>> news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>>>>
    >>>>>>>>
    >>>>>>>> I have 3 Query's
    >>>>>>>>
    >>>>>>>> Query1
    >>>>>>>> OwnerID (Number)
    >>>>>>>> OwnerLast Name (Text)
    >>>>>>>> OwnerFirst Name(Text)
    >>>>>>>>
    >>>>>>>> Query2
    >>>>>>>> HorseID (Number)
    >>>>>>>> HorseName (Text)
    >>>>>>>>
    >>>>>>>> Query3
    >>>>>>>> OwnerID (Number)
    >>>>>>>> HorseID (Number)
    >>>>>>>> OwnerPercent (Number%)
    >>>>>>>>
    >>>>>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>>>>> Name, HorseName, Owner Percenatge
    >>>>>>>> Can this be Done!
    >>>>>>>> Thanks in advance.........Bob Vance
    >>>>>>>>
    >>>>>>>
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  11. Bob

    Bob
    Expand Collapse
    Guest

    Graham where can I read up about adding Primary Keys
    Thanks Bob

    "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    news:%23s47JmwnGHA.3348@TK2MSFTNGP03.phx.gbl...
    > Hi Bob
    >
    > Well done getting the query working :)
    >
    > No, sorry, you have no control over the horizontal alignment of columns in
    > a listbox or combobox.
    >
    > PLEASE PLEASE PLEASE, for the sake of your future sanity, make sure that
    > you add proper indexes (primary keys at the very least!) into your tables,
    > and set up proper relationships to ensure referential integrity between
    > your tables.
    > --
    > Good Luck!
    >
    > Graham Mandeno [Access MVP]
    > Auckland, New Zealand
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e8cam0$5uf$1@lust.ihug.co.nz...
    >> Graham I now have 3 columns in my dropdown list can I make just the 3rd
    >> Column right align and the first 2 left align......Thanks Bob
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e8c9jb$42m$1@lust.ihug.co.nz...
    >>> UNBELIEVABLE I did it , I put the 3 Queries together then put lines
    >>> between HorseID to HorseID, OwnerID to OwnerID and that sent my records
    >>> from 18,000 to 39 Indivual Owners with there horses, I don't believe I
    >>> did it ,thanks for your help.......Bob :)
    >>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>> news:O$Ue3munGHA.4728@TK2MSFTNGP03.phx.gbl...
    >>>> Hi Bob
    >>>>
    >>>> It seems you are missing a few of the basics here :-S
    >>>>
    >>>> The "00" you see in Northwind is actually an infinity sign (an "8" on
    >>>> its side). It represents the "many" side of a one-to-many relationship
    >>>> (the "1" represents the "one" side).
    >>>>
    >>>> The bold fieldnames you see are the tables' primary keys. Do you not
    >>>> have primary keys, or other indexes, defined in your tables? Every one
    >>>> of your tables (with perhaps the occasional exception) ought to have a
    >>>> primary key. This is the means of uniquely identifying a record - a
    >>>> horse or an owner, for example. I had assumed that your fields HorseID
    >>>> and OwnerID were the primary keys in those respective tables.
    >>>>
    >>>> May I suggest again that you post back some details of your table
    >>>> designs (table names, field names and types).
    >>>>
    >>>> If you're desperate, you'll find me in the Auckland phone book.
    >>>> --
    >>>> Good Luck!
    >>>>
    >>>> Graham Mandeno [Access MVP]
    >>>> Auckland, New Zealand
    >>>>
    >>>> "Bob" <xxx@xx.xx> wrote in message news:e89sju$oar$1@lust.ihug.co.nz...
    >>>>> Looked at Northwind, they seem to get certain field names darker and
    >>>>> there link has 00 and 1 on the line
    >>>>> Is that how they should be linked not just the thin line
    >>>>> Thanks bob
    >>>>>
    >>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>> news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >>>>>> Hi Bob
    >>>>>>
    >>>>>> The related fields in your tables should be joined in the query.
    >>>>>> Have you ever created a multi-table query before? Have a look in the
    >>>>>> Northwind sample database - there are lots of examples.
    >>>>>>
    >>>>>> If you are still having trouble, post back some details of your table
    >>>>>> designs (table names, field names and types).
    >>>>>> --
    >>>>>> Good Luck!
    >>>>>>
    >>>>>> Graham Mandeno [Access MVP]
    >>>>>> Auckland, New Zealand
    >>>>>>
    >>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>> news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>>>>>> Graham , join which ones together
    >>>>>>> I have 3 Query tables in 1 table now!
    >>>>>>> Thanks Bob
    >>>>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>>>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>>>>>> Hi Bob
    >>>>>>>>
    >>>>>>>> No problem! Create a new query and add these three queries (or are
    >>>>>>>> they actually tables) into the design area. Make sure that there
    >>>>>>>> are joins between the two OwnerID fields and the two HorseID
    >>>>>>>> fields. Then simply add the four fields you want by dragging them
    >>>>>>>> down onto the query design grid.
    >>>>>>>> --
    >>>>>>>> Good Luck!
    >>>>>>>>
    >>>>>>>> Graham Mandeno [Access MVP]
    >>>>>>>> Auckland, New Zealand
    >>>>>>>>
    >>>>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>>>> news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>> I have 3 Query's
    >>>>>>>>>
    >>>>>>>>> Query1
    >>>>>>>>> OwnerID (Number)
    >>>>>>>>> OwnerLast Name (Text)
    >>>>>>>>> OwnerFirst Name(Text)
    >>>>>>>>>
    >>>>>>>>> Query2
    >>>>>>>>> HorseID (Number)
    >>>>>>>>> HorseName (Text)
    >>>>>>>>>
    >>>>>>>>> Query3
    >>>>>>>>> OwnerID (Number)
    >>>>>>>>> HorseID (Number)
    >>>>>>>>> OwnerPercent (Number%)
    >>>>>>>>>
    >>>>>>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>>>>>> Name, HorseName, Owner Percenatge
    >>>>>>>>> Can this be Done!
    >>>>>>>>> Thanks in advance.........Bob Vance
    >>>>>>>>>
    >>>>>>>>
    >>>>>>>>
    >>>>>>>
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  12. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    Where to begin? :)

    Jeff Conrad, the "Access Junkie", has a very good resource page here:
    http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

    Pay special attention to the "Database Design 101" section. There are also
    some very fine books listed under the "Book Recommendations" section. You
    may even find some of them in your public library.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "Bob" <xxx@xx.xx> wrote in message news:e8ervs$pld$1@lust.ihug.co.nz...
    > Graham where can I read up about adding Primary Keys
    > Thanks Bob
    >
    > "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    > news:%23s47JmwnGHA.3348@TK2MSFTNGP03.phx.gbl...
    >> Hi Bob
    >>
    >> Well done getting the query working :)
    >>
    >> No, sorry, you have no control over the horizontal alignment of columns
    >> in a listbox or combobox.
    >>
    >> PLEASE PLEASE PLEASE, for the sake of your future sanity, make sure that
    >> you add proper indexes (primary keys at the very least!) into your
    >> tables, and set up proper relationships to ensure referential integrity
    >> between your tables.
    >> --
    >> Good Luck!
    >>
    >> Graham Mandeno [Access MVP]
    >> Auckland, New Zealand
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e8cam0$5uf$1@lust.ihug.co.nz...
    >>> Graham I now have 3 columns in my dropdown list can I make just the 3rd
    >>> Column right align and the first 2 left align......Thanks Bob
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e8c9jb$42m$1@lust.ihug.co.nz...
    >>>> UNBELIEVABLE I did it , I put the 3 Queries together then put lines
    >>>> between HorseID to HorseID, OwnerID to OwnerID and that sent my records
    >>>> from 18,000 to 39 Indivual Owners with there horses, I don't believe I
    >>>> did it ,thanks for your help.......Bob :)
    >>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>> news:O$Ue3munGHA.4728@TK2MSFTNGP03.phx.gbl...
    >>>>> Hi Bob
    >>>>>
    >>>>> It seems you are missing a few of the basics here :-S
    >>>>>
    >>>>> The "00" you see in Northwind is actually an infinity sign (an "8" on
    >>>>> its side). It represents the "many" side of a one-to-many
    >>>>> relationship (the "1" represents the "one" side).
    >>>>>
    >>>>> The bold fieldnames you see are the tables' primary keys. Do you not
    >>>>> have primary keys, or other indexes, defined in your tables? Every
    >>>>> one of your tables (with perhaps the occasional exception) ought to
    >>>>> have a primary key. This is the means of uniquely identifying a
    >>>>> record - a horse or an owner, for example. I had assumed that your
    >>>>> fields HorseID and OwnerID were the primary keys in those respective
    >>>>> tables.
    >>>>>
    >>>>> May I suggest again that you post back some details of your table
    >>>>> designs (table names, field names and types).
    >>>>>
    >>>>> If you're desperate, you'll find me in the Auckland phone book.
    >>>>> --
    >>>>> Good Luck!
    >>>>>
    >>>>> Graham Mandeno [Access MVP]
    >>>>> Auckland, New Zealand
    >>>>>
    >>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>> news:e89sju$oar$1@lust.ihug.co.nz...
    >>>>>> Looked at Northwind, they seem to get certain field names darker and
    >>>>>> there link has 00 and 1 on the line
    >>>>>> Is that how they should be linked not just the thin line
    >>>>>> Thanks bob
    >>>>>>
    >>>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>>> news:%237F%23MAknGHA.776@TK2MSFTNGP04.phx.gbl...
    >>>>>>> Hi Bob
    >>>>>>>
    >>>>>>> The related fields in your tables should be joined in the query.
    >>>>>>> Have you ever created a multi-table query before? Have a look in
    >>>>>>> the Northwind sample database - there are lots of examples.
    >>>>>>>
    >>>>>>> If you are still having trouble, post back some details of your
    >>>>>>> table designs (table names, field names and types).
    >>>>>>> --
    >>>>>>> Good Luck!
    >>>>>>>
    >>>>>>> Graham Mandeno [Access MVP]
    >>>>>>> Auckland, New Zealand
    >>>>>>>
    >>>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>>> news:e89q8c$k3k$1@lust.ihug.co.nz...
    >>>>>>>> Graham , join which ones together
    >>>>>>>> I have 3 Query tables in 1 table now!
    >>>>>>>> Thanks Bob
    >>>>>>>> "Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
    >>>>>>>> news:ObyqdejnGHA.4240@TK2MSFTNGP02.phx.gbl...
    >>>>>>>>> Hi Bob
    >>>>>>>>>
    >>>>>>>>> No problem! Create a new query and add these three queries (or
    >>>>>>>>> are they actually tables) into the design area. Make sure that
    >>>>>>>>> there are joins between the two OwnerID fields and the two HorseID
    >>>>>>>>> fields. Then simply add the four fields you want by dragging them
    >>>>>>>>> down onto the query design grid.
    >>>>>>>>> --
    >>>>>>>>> Good Luck!
    >>>>>>>>>
    >>>>>>>>> Graham Mandeno [Access MVP]
    >>>>>>>>> Auckland, New Zealand
    >>>>>>>>>
    >>>>>>>>> "Bob" <xxx@xx.xx> wrote in message
    >>>>>>>>> news:e89mon$dnf$1@lust.ihug.co.nz...
    >>>>>>>>>>
    >>>>>>>>>>
    >>>>>>>>>> I have 3 Query's
    >>>>>>>>>>
    >>>>>>>>>> Query1
    >>>>>>>>>> OwnerID (Number)
    >>>>>>>>>> OwnerLast Name (Text)
    >>>>>>>>>> OwnerFirst Name(Text)
    >>>>>>>>>>
    >>>>>>>>>> Query2
    >>>>>>>>>> HorseID (Number)
    >>>>>>>>>> HorseName (Text)
    >>>>>>>>>>
    >>>>>>>>>> Query3
    >>>>>>>>>> OwnerID (Number)
    >>>>>>>>>> HorseID (Number)
    >>>>>>>>>> OwnerPercent (Number%)
    >>>>>>>>>>
    >>>>>>>>>> What I want is to have a query that has OwnerLast Name,OwnerFirst
    >>>>>>>>>> Name, HorseName, Owner Percenatge
    >>>>>>>>>> Can this be Done!
    >>>>>>>>>> Thanks in advance.........Bob Vance
    >>>>>>>>>>
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>
    >>>>>>>>
    >>>>>>>
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page