Query asking for dates twice

[Gale Coleman]

Hello all,

I am using Access 2000 with Windows 2000. I have a query that I have a
between date written in it ( Between [Enter opening date] And [Enter ending
opening date])

The query ran really good for awhile until I tried different things with it,
then it started asking for the dates twice in a row before it would give me
the results of the query.

How do I get it to quit asking for the dates twice? I have compacted and
repaired the database. I have my front end and back end split up. Data in
the backend, queries and reports in the front end.

Thanks for any suggestions!

Gale


Following is the query:

SELECT CLIENTSW.CASENUM, CLIENTSW.OFFICENUM, CLIENTSW.CASETYPE,
CLIENTSW.PCODE, CLIENTSW.CLNAME, CLIENTSW.CFNAME, CLIENTSW.DOPEN,
CLIENTSW.DCLOSED, CLIENTSW.RCLOSED, LITIGATION.Casenum,
LITIGATION.Protected, LITIGATION.ProtectedReason, LITIGATION.ClientIs,
LITIGATION.CauseofAction, LITIGATION.Judge1, LITIGATION.Judge2,
LITIGATION.Judge3, LITIGATION.CourtName1, LITIGATION.CourtName2,
LITIGATION.CourtName3, LITIGATION.CourtNum1, LITIGATION.CourtNum2,
LITIGATION.CourtNum3, LITIGATION.CourtAdd1, LITIGATION.CourtAdd2,
LITIGATION.CourtAdd3, LITIGATION.CourtCity1, LITIGATION.CourtCity2,
LITIGATION.CourtCity3, LITIGATION.CourtZip1, LITIGATION.CourtZip2,
LITIGATION.CourtZip3, LITIGATION.CourtState1, LITIGATION.CourtState2,
LITIGATION.CourtState3, LITIGATION.DateB1, LITIGATION.DateE1,
LITIGATION.DateB2, LITIGATION.DateE2, LITIGATION.DateB3, LITIGATION.DateE3,
CLIENTSW.SNUM, CLIENTSW.FUNDSNUM, CLIENTSW.CADDRESS, CLIENTSW.CCITY,
CLIENTSW.CSTATE, CLIENTSW.CZIP, CLIENTSW.CACODE, CLIENTSW.CPHONE,
LITIGATIONPARTY.PartyFname, LITIGATIONPARTY.PartyLname,
LITIGATIONPARTY.PartyAddress, LITIGATIONPARTY.PartyCity,
LITIGATIONPARTY.PartyState, LITIGATIONPARTY.PartyZip, LITIGATION.ClientIs,
LITIGATIONPARTY.PartyIs, LITIGATION.DateB1
FROM (CLIENTSW LEFT JOIN LITIGATION ON CLIENTSW.CASENUM =
LITIGATION.Casenum) INNER JOIN LITIGATIONPARTY ON CLIENTSW.CASENUM =
LITIGATIONPARTY.Casenum
WHERE (((LITIGATION.Casenum) Is Not Null) AND ((LITIGATION.DateB1) Between
[Enter opening date] And [Enter ending opening date]));

 

[Guest]

hi,
that happens to me occasionally. don't know what causes it
but delete your parameters and save the query. re-input
your parameters and save the query. quirky i know but it
works.
regards.

 

[Gale Coleman]

Thank you,

That worked in all but one query where it is based on another query.

Gale