Not getting any data back , must be my query?

[Matrix.net]

Hi I'm writing an application using MSACCESS . I'm not getting any data when I should . Heres my query:

SELECT Civilpartynames3.CaseNumber,Civilpartynames3.PartyNameFull,Civilpartynames3.Ty,Civilpartyn ames3.Filing,Civilpartynames3.CAT,Civilpartynames3.CSID,Civilattynames.AttyNm FROM Civilpartynames3,Civilattynames Where Civilpartynames3.CaseNumber = 'C-0048-AB-2000-00002' AND PartyNameFull LIKE 'GL&V/DORR-OLIVER INC%' AND Ty = 'D' AND AttyNm = 'BASIL A DISIPIO ESQ' AND Civilattynames.CaseNumber = Civilpartynames3.CaseNumber AND Filing =12/30/1999 AND Civilpartynames3.CAT = 'AB'

basically I want to join Civilpartynames3 and CivilAttynames then pull those records that have a matching caseNumber and that the civilAttyName equals 'Basil A Disipio ESQ'

the join function isnt supported in MSACCESS so I'm left with trying to do it strictly with querying.

[pclement]

If Filing is a Date field then you would need to enclose the date using pound sign characters.

Filing = #12/30/1999#

[Matrix.net]

Thanks ! will try though I could've sworn I didnt have to put in pound signs in my other code . This freaking thing is so big I dont remember everything I've done .

[Phil Weber]

Why do you say that the JOIN function isn't supported in Access? Sure it is.

[Matrix.net]

It works now, thanks