Thanks John. I need to import some test data before I can try that.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> John-
>
> I suspect you want the number part to always be the same length. To do that,
> use the Format function:
>
> ConcatFld: [Abbreviation] & Format([SeqNo], "0000")
>
> That will take your sequence number and make it always appear as 4 digits. The
> number 1 will appear as 0001.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of yshopper
> Sent: Wednesday, November 30, 2011 8:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup
> field
>
> Crystal,
> The Number field is just an auto-sequence field from 1 to 1000 using
> instructions located here
>
> http://rogersaccessblog.blogspot.com/2010/12/domain-function-example-simulate.ht
> ml
>
> The lookup field are Abbreviations of Collection Names. I need to label each box
> shipped with a sequential number and a unique identifier, i.e. the abbreviation.
>
> Thanks,
> John
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@>
> wrote:
> >
> > Hi John,
> >
> > Would you first explain the logic of why you want to do this? And what kind
> of data do you have? Thanks
> >
> > Warm Regards,
> > Crystal
> >
> > Access Basics by Crystal (Bill Mosca's site)
> > http://thatlldoit.com
> > Free 100-page book that covers essentials in Access
> >
> > *
> > (: have an awesome day :)
> > *
> >
> >
> >
> > ________________________________
> > From: yshopper
> > Subject: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup
> field
> >
> > I have an auto-sequence number field that I need to concatenate with a Lookup
> text box on a form.
> >
> > I got the auto-number to work and the lookup is on the form, but how do I
> concatenate the 2 fields that are in 2 different tables that are related only
> through another table?
> >
> > I see how to do it with fields in the same table, but not with fields in
> different tables.
> >
> > TIA,
> > John
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar