Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining Data in Two Fields into One New Field (2002)

    Hello Lounge:

    I am trying to combine the date in one field with the data in a second field (both in the same record) to create a combined new field.

    For example: Field1 = 408 and Field2 = 635, I would like to create Field3 = 408635

    Is this possible? Any help would be greatly appreciated.

    Thanks,
    Craig

  2. #2
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining Data in Two Fields into One New Field (2002)

    Craig,

    you should be able to do this in an append query. Are you familiar with this if not I will post instructionson how to do this. You will need to create a new field in your table or would add the second field onto the end of the data in the first field.
    Best Regards,

    Luke

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining Data in Two Fields into One New Field (2002)

    Sorry I think I may have got this wrong, and update query is what you need. Sorry new to access myself and trying to contribute to the forum and gain assistance.
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining Data in Two Fields into One New Field (2002)

    Strictly speaking, you don't need a new field in the table, since it is derived information. You can calculate the combined value in a query, and use this query as the basis for reports, forms and perhaps other queries. You'd define the calculated field as

    Field3: [Field1] & [Field2]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •