Help with Query!

May i see also the tblHorseInfo

tblHorseInfo HorseID HorseName MotherName FatherName Sex DateOfBirth Race
HorsePrice StableReturnDate Remark Status Worksheet
1 Kazarokin Pianosa Anziyan Geld 2001
$20,000.00 29/04/2006
Active Yes
2
Itza Beel Anziyan Geld 2002
$0.00 30/04/2006
Finished No
3 Milena Tiana Stravinski Filly 2001
$0.00

Finished No
4 Colombian Princess Isabella Columbia Filly 2001
$0.00

Finished No
5
Panza Anne McGinty Geld 2001
$0.00

Finished No
6
Zipperup O'Riley Geld 2002
$0.00 18/09/2005
Finished No
7 Restitution Kaska Daggers Drawn Geld 2001
$13,000.00 23/01/2006
Active Yes
8 Desert Queen Queens Honour Daggers Drawn Filly 2002
$0.00 16/05/2005
Finished No
9 Tee Gee Blue Reality Anziyan Geld 2002
$0.00 18/09/2005
Finished No
10 Delay No More Kowtow Woodbough Geld 2002
$0.00 18/09/2005
Active Yes
11 Mulroy Bay Champagne On Ice Anziyan Geld 2000
$18,000.00 28/03/2005
Finished No
12 Sand Hawk Majestic Hunter Sandtrap Geld 2003
$20,000.00 16/03/2006
Finished No
13 Tiara Sands Kara Kum Sandtrap Filly 2003
$8,500.00 16/03/2006
Finished Yes
14
Resolve Columbia Geld 2003
$19,000.00

Finished No
15
Zivania Johan Cruyff Geld 2003
$0.00

Finished No
16
Snow Goddess Quorum Filly 2002
$0.00

Finished No
17 Cut And Trust Sister Mary Daggers Drawn Geld 2002
$0.00 4/06/2005
Finished No
18 My Lips Ar Sealed It's a secret Maroof Geld 2000
$0.00 18/09/2005
Active Yes
19 Providence Bay


2000
$0.00 21/06/2005
Finished No
22 Kollegi Learnalot Anziyan Geld 2003
$14,000.00 16/03/2006
Active Yes
24 Belle Of Marju

Filly 2001
$0.00 1/04/2006
Active Yes
27
Zivania Desert Fox Colt 2004
$0.00

Active Yes

wrote in message
oups.com...
May i see also the tblHorseInfo

SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false)
AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdl)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);


Note:

All of your horses with status "Active" in the tblHorseInfo
are already in tblInvoice_ItMdt that's why you will get 0 record.


the tbl

I tried putting other horses in active mode, that where not in
TblInvoice_ItMdl but still no horses are showing..thanks Bob
wrote in message
ups.com...
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false)
AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdl)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);


Note:

All of your horses with status "Active" in the tblHorseInfo
are already in tblInvoice_ItMdt that's why you will get 0 record.


the tbl

Might have something to do with qryOrderByHorseName because I am getting a
error on the drop down list now. Thanx Bob
"Bob" wrote in message ...
I tried putting other horses in active mode, that where not in
TblInvoice_ItMdl but still no horses are showing..thanks Bob
wrote in message
ups.com...
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false)
AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdl)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);


Note:

All of your horses with status "Active" in the tblHorseInfo
are already in tblInvoice_ItMdt that's why you will get 0 record.


the tbl

qryOrderByHorseName HorseID Name StableReturnDate
27 Desert Fox--Zivania-- 1 yo--Colt

24 Belle Of Marju 1/04/2006
10 Delay No More 18/09/2005
1 Kazarokin 29/04/2006
22 Kollegi 16/03/2006
18 My Lips Ar Sealed 18/09/2005
7 Restitution 23/01/2006


"Bob" wrote in message ...
Might have something to do with qryOrderByHorseName because I am getting a
error on the drop down list now. Thanx Bob
"Bob" wrote in message ...
I tried putting other horses in active mode, that where not in
TblInvoice_ItMdl but still no horses are showing..thanks Bob
wrote in message
ups.com...
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false)
AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdl)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);


Note:

All of your horses with status "Active" in the tblHorseInfo
are already in tblInvoice_ItMdt that's why you will get 0 record.


the tbl

This actually lists the horses by alphabetical order, Unnamed horses first
then Named Horses... Thanks Bob

"Bob" wrote in message ...

qryOrderByHorseName HorseID Name StableReturnDate
27 Desert Fox--Zivania-- 1 yo--Colt

24 Belle Of Marju 1/04/2006
10 Delay No More 18/09/2005
1 Kazarokin 29/04/2006
22 Kollegi 16/03/2006
18 My Lips Ar Sealed 18/09/2005
7 Restitution 23/01/2006


"Bob" wrote in message ...
Might have something to do with qryOrderByHorseName because I am getting
a error on the drop down list now. Thanx Bob
"Bob" wrote in message ...
I tried putting other horses in active mode, that where not in
TblInvoice_ItMdl but still no horses are showing..thanks Bob
wrote in message
ups.com...
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false)
AS
Name, [StableReturnDate]
FROM tblHorseInfo
WHERE Status LIKE 'Active*' AND
tblHorseInfo.HorseID NOT IN
(SELECT HorseID FROM TblInvoice_ItMdl)
ORDER BY funGetHorse(0,tblHorseInfo.HorseID,true),
funGetHorse(0,tblHorseInfo.HorseID,false);


Note:

All of your horses with status "Active" in the tblHorseInfo
are already in tblInvoice_ItMdt that's why you will get 0 record.


the tbl

It works here.i tried to set some horses
in active status that were not in the TblInvoice_ItMdl
and it showed here.

OK Arthur I know now I can get your code to save, what am I doing
wrong....Thanx Bob

wrote in message
ups.com...
It works here.i tried to set some horses
in active status that were not in the TblInvoice_ItMdl
and it showed here.

Ah Ha
(SELECT HorseID FROM TblInvoice_ItMdl) should be
(SELECT HorseID FROM TblInvoice_ItMdt)
Thanks but still got prob with my drop down active horse list....Thanks
Brilliant Bob

"Bob" wrote in message ...
OK Arthur I know now I can get your code to save, what am I doing
wrong....Thanx Bob

wrote in message
ups.com...
It works here.i tried to set some horses
in active status that were not in the TblInvoice_ItMdl
and it showed here.