Combine Fields

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have a table that has 3 fields named one, two & three. I created a field
named Notes. I want to put the infor in fields one, two & three into Notes
I created a update query with the following:

Field:Notes
Table:Microfilm
Update To:[one] & " " & [two] & " " & [three]

but I get 0 0
 
What kind of fields are [one], [two], and [three]?

What did you get when you run a select query with --
[one] & " " & [two] & " " & [three]
 
I have a table that has 3 fields named one, two & three. I created a field
named Notes. I want to put the infor in fields one, two & three into Notes
I created a update query with the following:

Field:Notes
Table:Microfilm
Update To:[one] & " " & [two] & " " & [three]

but I get 0 0
Click to expand...

First off... you probably DON'T want to store this Notes field redundantly.
What if you run the update query, put some text into Notes, and then edit the
values in [one] and [three]? They'll be different, and you'll have no way to
tell.

Secondly, I really suspect that the fields don't contain what they appear to.
Are they perhaps Lookup Fields? If so, it *looks* like they contain text
(picked from a combo box) but they actually contain a concealed number.

More info please!
 
Karl, thanks for your response. All 4 fields are text fields. I "notes" I
got 0 0
--
NotGood@All


KARL DEWEY said:
What kind of fields are [one], [two], and [three]?

What did you get when you run a select query with --
[one] & " " & [two] & " " & [three]


NotGood@All said:
I have a table that has 3 fields named one, two & three. I created a field
named Notes. I want to put the infor in fields one, two & three into Notes
I created a update query with the following:

Field:Notes
Table:Microfilm
Update To:[one] & " " & [two] & " " & [three]

but I get 0 0
Click to expand...
Click to expand...
 
John, thanks. There are no forms, no dropdowns, just this 1 table. Someone
created 3 fields for some info that could be in 1 Its like a first name & a
last name. I just want to put them back together
--
NotGood@All


John W. Vinson said:
I have a table that has 3 fields named one, two & three. I created a field
named Notes. I want to put the infor in fields one, two & three into Notes
I created a update query with the following:

Field:Notes
Table:Microfilm
Update To:[one] & " " & [two] & " " & [three]

but I get 0 0
Click to expand...

First off... you probably DON'T want to store this Notes field redundantly.
What if you run the update query, put some text into Notes, and then edit the
values in [one] and [three]? They'll be different, and you'll have no way to
tell.

Secondly, I really suspect that the fields don't contain what they appear to.
Are they perhaps Lookup Fields? If so, it *looks* like they contain text
(picked from a combo box) but they actually contain a concealed number.

More info please!
Click to expand...
 
John, thanks. There are no forms, no dropdowns, just this 1 table. Someone
created 3 fields for some info that could be in 1 Its like a first name & a
last name. I just want to put them back together
Click to expand...

Please post a few sample records with the result you desire, and the result
you're actually getting (along with the actual SQL of your update query). This
isn't making sense to me!
 
Back
Top