Combine Fields

[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

 

[KARL DEWEY]

What kind of fields are [one], [two], and [three]?

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

 

[John W. Vinson]

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

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!

 

[NotGood@All]

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

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

 

[NotGood@All]

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

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

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!

 

[John W. Vinson]

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

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!