L
Lyra
Hello,
I'm using Access 2003 at home and Access 2000 at work. I have created a
report and within a text box am trying to call my procedure using this code
in the expression builder
=AmountToPay([CRN],[sub_ssn],[Forms]![frm_Run_Reports]![txtStartingDate],[Forms]![frm_Run_Reports]![txtEndingDate],[provider_num])
This works great on the Access 2003 version (by the way I keep it saved in
Access 2000 format when working with it in 2003). When I bring it back into
the office it adds brackets around the procedure and therefore will not work.
=[AmountToPay]([CRN],[sub_ssn],[Forms]![frm_Run_Reports]![txtStartingDate],[Forms]![frm_Run_Reports]![txtEndingDate],[provider_num])
Any suggestions? I have updated to SP3 and I have tried taking out the
brackets manually but everytime I save the report or try to run the report,
it puts those brackets back in. And sometimes, when I bring the database
into work, the report will have no problems whatsoever.
Many thanks!!
I'm using Access 2003 at home and Access 2000 at work. I have created a
report and within a text box am trying to call my procedure using this code
in the expression builder
=AmountToPay([CRN],[sub_ssn],[Forms]![frm_Run_Reports]![txtStartingDate],[Forms]![frm_Run_Reports]![txtEndingDate],[provider_num])
This works great on the Access 2003 version (by the way I keep it saved in
Access 2000 format when working with it in 2003). When I bring it back into
the office it adds brackets around the procedure and therefore will not work.
=[AmountToPay]([CRN],[sub_ssn],[Forms]![frm_Run_Reports]![txtStartingDate],[Forms]![frm_Run_Reports]![txtEndingDate],[provider_num])
Any suggestions? I have updated to SP3 and I have tried taking out the
brackets manually but everytime I save the report or try to run the report,
it puts those brackets back in. And sometimes, when I bring the database
into work, the report will have no problems whatsoever.
Many thanks!!