A
AFSSkier
I have a new queried report that takes the PRODUCT table inner-joined with a
CrossTab query, CT_ZONE_PRICE. I’m having trouble with a form that the user
can choose only their regional ZONE & get only their columnized regional
pricing.
I can do this by 1st manually filtering the field named [ZONE] in the
ZONE_PRICE Query that the CT_ZONE_PRICE is CrossTab queried from. Then run
the macros to create the reports. I tried with Form filter “Like
[Forms]![ZONE_PRICE_ Form]![ZONE]†within the ZONE_PRICE Query & also with a
ApplyFilter in a macro, “WHERE ((([ZONES].ZONE) Like [Forms]![ZONE_PRICE_
Form]![ZONE]))â€.
The SALES_REPORTS form below works for a simple query report.
This form has several combo boxes where a user can choose the filtering
criteria for their reports. This form runs great with the following DoCmd.
Private Sub Command6_Click()
Me.Visible = False
DoCmd.OpenQuery "MT_PROD_SALES", acViewNormal, acEdit
DoCmd.Close acForm, "SALES_REPORTS"
DoCmd.RunMacro "SALES_Macro"
End Sub
CrossTab query, CT_ZONE_PRICE. I’m having trouble with a form that the user
can choose only their regional ZONE & get only their columnized regional
pricing.
I can do this by 1st manually filtering the field named [ZONE] in the
ZONE_PRICE Query that the CT_ZONE_PRICE is CrossTab queried from. Then run
the macros to create the reports. I tried with Form filter “Like
[Forms]![ZONE_PRICE_ Form]![ZONE]†within the ZONE_PRICE Query & also with a
ApplyFilter in a macro, “WHERE ((([ZONES].ZONE) Like [Forms]![ZONE_PRICE_
Form]![ZONE]))â€.
The SALES_REPORTS form below works for a simple query report.
This form has several combo boxes where a user can choose the filtering
criteria for their reports. This form runs great with the following DoCmd.
Private Sub Command6_Click()
Me.Visible = False
DoCmd.OpenQuery "MT_PROD_SALES", acViewNormal, acEdit
DoCmd.Close acForm, "SALES_REPORTS"
DoCmd.RunMacro "SALES_Macro"
End Sub