Can This be Done!

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
 
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.
 
Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
Graham Mandeno said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
Graham Mandeno said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
Graham Mandeno said:
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



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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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

Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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

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

Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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

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

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

Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
Graham where can I read up about adding Primary Keys
Thanks Bob

Graham Mandeno said:
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 said:
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 said:
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 :)
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

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

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

Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
Graham where can I read up about adding Primary Keys
Thanks Bob

Graham Mandeno said:
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 said:
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

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 :)
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

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

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

Graham , join which ones together
I have 3 Query tables in 1 table now!
Thanks Bob
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



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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top