Subreport problem w/filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CEV - 26 Dec 2006 20:53 GMT

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

Reply to this Message

CEV - 26 Dec 2006 21:03 GMT

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

>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
[quoted text clipped - 8 lines]
>
> Chad

Reply to this Message

Marshall Barton - 26 Dec 2006 21:28 GMT

>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
[quoted text clipped - 8 lines]
>>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)

Signature

Marsh
MVP [MS Access]

Reply to this Message

Wei Lu [MSFT] - 29 Dec 2006 08:56 GMT

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.

Reply to this Message