Subreport problem w/filtering

[CEV]

I have a subreport that will be showing info from a table. I want it only to
show records that do not contain data in the "Date Stopped" field. In the
subreport properties, I have ([Medication History].Date Stopped Is Null)
entered for the Filter. The Filter On is set to Yes. I also want to order
the records by the "Date Started" field so I entered [Date Started] in the
Order By and set Order By On to Yes but that keeps changeing to No for some
reason. This is really 2 issues but would appreciate any help I can get.

Thanks,

Chad

 

[CEV]

I forgot to mention that the first issue is that when I try to open the
report I get a Missing Operator error in referance to ([Medication
History].Date Stopped Is Null) .

Thanks,

Chad

 

[Marshall Barton]

I forgot to mention that the first issue is that when I try to open the
report I get a Missing Operator error in referance to ([Medication
History].Date Stopped Is Null) .

I have a subreport that will be showing info from a table. I want it only
to show records that do not contain data in the "Date Stopped" field. In
the subreport properties, I have ([Medication History].Date Stopped Is
Null) entered for the Filter. The Filter On is set to Yes. I also want to
order the records by the "Date Started" field so I entered [Date Started]
in the Order By and set Order By On to Yes but that keeps changeing to No
for some reason. This is really 2 issues but would appreciate any help I
can get.

The basic syntax rules require [ ] around any name that
xontains a non-alphanumeric character (including a space.

([Medication History].[Date Stopped] Is Null)

 

[Wei Lu [MSFT]]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.