List box - query

[Bill]

Hi,

I am running a report that link to Query A. The "Query A" is a crosstab
with few rows and column. I made the form that has a list box which is only
two name (Active & Inactive). On the form, I select "Active", I am able to
open the query with data same as "Inactive". I try to use blank on the
list box and get Active and Inactive into one query but I couldn't get any
data.

I have put "Is null" in the query.

example:
[Forms]![FormName]![Files] or IS Null

Is that correct for the crosstab query? I have no problem with normal
queries using this code but not for crosstab. I am trying to get both
(Active and Inactive).

Your help would be much appreciated.

 

[Mingqing Cheng [MSFT]]

Hi Bill,

I would appreciate your patience while I am looking into this issue. I will
post my response at soon as I have update for you.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support

 

[Mingqing Cheng [MSFT]]

Hi Bill,

Would you please show me an example mdb file? IMO, we need parameters to
make a crosstab query. You could send your sample files to
(e-mail address removed) (remeber to remove online, which is prepared
for SPAM) More detailed information, I believe, will make us closer to the
resolution

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support