concatenate string to call a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I am passing an openargs. I will be using the openargs
in the report title and I want to use it to check 2 field conditions. I pass
Jan, Mar, May, Jul, Sep or Nov. I want to check the condition of Jan1 and
Jan2 or Mar1 and Mar2 and so on. How do I combine the string I passed and
the 1 and 2 so that it is a field [Jan1], [Jan2]. I hope this makes some
sense.

Thanks for your help.

Sarah
 
Sarah,

If I understand you correctly, you are looking for this syntax...

Me(Me.OpenArgs & "1")
 
Yes! Exactly what I was looking for.

Thanks!

Steve Schapel said:
Sarah,

If I understand you correctly, you are looking for this syntax...

Me(Me.OpenArgs & "1")

--
Steve Schapel, Microsoft Access MVP
I have a report that I am passing an openargs. I will be using the openargs
in the report title and I want to use it to check 2 field conditions. I pass
Jan, Mar, May, Jul, Sep or Nov. I want to check the condition of Jan1 and
Jan2 or Mar1 and Mar2 and so on. How do I combine the string I passed and
the 1 and 2 so that it is a field [Jan1], [Jan2]. I hope this makes some
sense.

Thanks for your help.

Sarah
Click to expand...
Click to expand...
 
Back
Top