jeran042
Registered User.
- Local time
- Today, 14:08
- Joined
- Jun 26, 2017
- Messages
- 127
Good morning all,
I have a report with some calculated fields on it. And these fields are hyperlinked to open a form with the detail that makes up the calculation.
On that form, there is a button to export the details to excel (via ExportWithFormatting), and everything works fine if there is only one variable in the [COST_CENTER] field. Meaning, if you are exporting the detail and it is only looking at 1 number it exports with no issue.
The problem lies when you open a form with multiple [COST_CENTER], the where clause is only picking up the fist variable. Below is a sample of the where clause I am using,
My question is, how can I adjust this to pick up all the variables?
,
Very much appreciated,
I have a report with some calculated fields on it. And these fields are hyperlinked to open a form with the detail that makes up the calculation.
On that form, there is a button to export the details to excel (via ExportWithFormatting), and everything works fine if there is only one variable in the [COST_CENTER] field. Meaning, if you are exporting the detail and it is only looking at 1 number it exports with no issue.
The problem lies when you open a form with multiple [COST_CENTER], the where clause is only picking up the fist variable. Below is a sample of the where clause I am using,
My question is, how can I adjust this to pick up all the variables?
Code:
[COST_CENTER]=[Forms]![frm: Head Count]![COST_CENTER]
Very much appreciated,