ACCESS FEED: RE: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup field

Rabu, 30 November 2011

RE: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup field

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