D
DeepTrouble
Hi,
I have a cross-tab query built on another query. I have created a
form to display the cross-tab query. Now, I would like to restrict the
results of the cross-tab query by passing a couple of params to the
base query. Am just not getting anywhere. Can someone please help?
Here is some more info on this.
Base query: qrySLA Summary
Columns: apart from plenty of others, includes "Resolved Date &
Time" (Date/Time)
Cross-tab query: qry SLA Summary Cross-tab
columns: does *not* include "Resolved Date & Time"
Form: frmSLA Summary
Form is based on: qry SLA Summary Cross-tab
Parameters available in : 2 text fields (txtFromDate and txtToDate)
Now, I tried to reference the text fields from the base query. But, I
get an error - Jet database engine does not recognize [Forms]![frmSLA
Summary]!txtFromDate as a valid field or expression. I have also tried
to declare global variables and tried passing them as parameters -
doesnt work. I have tried bringing the "Resolved Date & Time" field
into the cross-tab query, but, that doesnt work either.
Can anyone tell me where I am being wrong? Thanks a lot in advance.
Will let you know if I discover anything.
Do let me know if you'd like more info.
I have a cross-tab query built on another query. I have created a
form to display the cross-tab query. Now, I would like to restrict the
results of the cross-tab query by passing a couple of params to the
base query. Am just not getting anywhere. Can someone please help?
Here is some more info on this.
Base query: qrySLA Summary
Columns: apart from plenty of others, includes "Resolved Date &
Time" (Date/Time)
Cross-tab query: qry SLA Summary Cross-tab
columns: does *not* include "Resolved Date & Time"
Form: frmSLA Summary
Form is based on: qry SLA Summary Cross-tab
Parameters available in : 2 text fields (txtFromDate and txtToDate)
Now, I tried to reference the text fields from the base query. But, I
get an error - Jet database engine does not recognize [Forms]![frmSLA
Summary]!txtFromDate as a valid field or expression. I have also tried
to declare global variables and tried passing them as parameters -
doesnt work. I have tried bringing the "Resolved Date & Time" field
into the cross-tab query, but, that doesnt work either.
Can anyone tell me where I am being wrong? Thanks a lot in advance.
Will let you know if I discover anything.
Do let me know if you'd like more info.