Prev: Combine data from 2 queries
Next: is it possible to change Report_Open to something that opens a que
From: Emma on 26 Apr 2010 14:14
Thanks John it's working now that I called the textbox Financial ID and used
ID as the reference it stopped the circular reference. Thanks so much!

"John W. Vinson" wrote:

> On Mon, 26 Apr 2010 07:30:02 -0700, Emma <Emma(a)discussions.microsoft.com>
> wrote:
>
> >I want to say
> >="HELP"&Format([Session Start Date 2],"yyyy\:mm") & [ID]
> >I want the word HELP then the start date 2 and finally the ID
> >ie: HELP2010:12430
> >How do I put the text at the beginning?
>
> What you proposed should work correctly, if it's in the Control Source of the
> textbox. I'd add some blanks:
>
> ="HELP" & Format([Session Start Date 2],"yyyy\:mm") & [ID]
>
> If this isn't working for you please amplify - what's the context? Is this on
> a Form, a Report, in a query? What error are you getting?
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Combine data from 2 queries
Next: is it possible to change Report_Open to something that opens a que