How to Get Filters to Work in Access 2000 from Access 1997 Database

  • Thread starter Thread starter DOYLE60
  • Start date Start date
D

DOYLE60

I have a database built in Access 1997, and it works just fine. But when I
convert it to Access 2000, some filters don't seem to work. A report that
should give results, gives nothing, just errors, errors, errors, on the
calculations.

One such filter that doesn't work is this:

Like
(IIf(IsNull([Forms]![RFDialogPrintfrm]![FranchiseChosen]),"*","|[Forms]![R
FDialogPrintfrm]![FranchiseChosen]|"))

Anything wrong with that in Access 2000?

Thanks,

Matt
 
You shouldn't have the quotes and "|" around the final form and control
reference. Try:
Like IIf(IsNull([Forms]![RFDialogPrintfrm]![FranchiseChosen]),
"*" , [Forms]![RFDialogPrintfrm]![FranchiseChosen])
Or
Like Nz([Forms]![RFDialogPrintfrm]![FranchiseChosen], "*")
 
Duane,
I forgot to thank you. It worked. Thanks so much.

Matt


Subject: Re: How to Get Filters to Work in Access 2000 from Access 1997
Database
From: "Duane Hookom" duanehookom@NO_SPAMhotmail.com
Date: 12/7/2004 10:30 PM Eastern Standard Time
Message-id: <[email protected]>

You shouldn't have the quotes and "|" around the final form and control
reference. Try:
Like IIf(IsNull([Forms]![RFDialogPrintfrm]![FranchiseChosen]),
"*" , [Forms]![RFDialogPrintfrm]![FranchiseChosen])
Or
Like Nz([Forms]![RFDialogPrintfrm]![FranchiseChosen], "*")

--
Duane Hookom
MS Access MVP


DOYLE60 said:
I have a database built in Access 1997, and it works just fine. But when I
convert it to Access 2000, some filters don't seem to work. A report that
should give results, gives nothing, just errors, errors, errors, on the
calculations.

One such filter that doesn't work is this:

Like
(IIf(IsNull([Forms]![RFDialogPrintfrm]![FranchiseChosen]),"*","|[Forms]![R
FDialogPrintfrm]![FranchiseChosen]|"))

Anything wrong with that in Access 2000?

Thanks,

Matt
Click to expand...
Click to expand...
 
Back
Top