How to duplicate fielddata and add some data to it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody,

can anybody tell me how to solve my next problem :

I have a table with a field (text) which can contain 4 characters.
An new field has to be continuesly filled up with a copy of these 4
characters,
including a "0" at the front or end (so total 5 characters).
I do not use Access itself but just the MDB (use access just to design the
database).

Also I like to know how to make DECIMAL data in a field,
copied in the same way to a new field in HEXADECIMAL format.

Can anybody help me ?
 
Thanks,

how can I let this query run realtime ?



Alex Dybenko said:
Hi,
best - is you use Update query. add a new field to your table and then make
a table which looks like:

Update MyTable Set newField="0" & [OldField]

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


Jeroen said:
Hi everybody,

can anybody tell me how to solve my next problem :

I have a table with a field (text) which can contain 4 characters.
An new field has to be continuesly filled up with a copy of these 4
characters,
including a "0" at the front or end (so total 5 characters).
I do not use Access itself but just the MDB (use access just to design the
database).

Also I like to know how to make DECIMAL data in a field,
copied in the same way to a new field in HEXADECIMAL format.

Can anybody help me ?
Click to expand...
Click to expand...
 
if you have saved this query - then you can run it using docmd.openquery
"myquery"
else - using:
docmd.runsql "Update MyTable Set newField='0' & [OldField]"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Jeroen said:
Thanks,

how can I let this query run realtime ?



Alex Dybenko said:
Hi,
best - is you use Update query. add a new field to your table and then
make
a table which looks like:

Update MyTable Set newField="0" & [OldField]

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


Jeroen said:
Hi everybody,

can anybody tell me how to solve my next problem :

I have a table with a field (text) which can contain 4 characters.
An new field has to be continuesly filled up with a copy of these 4
characters,
including a "0" at the front or end (so total 5 characters).
I do not use Access itself but just the MDB (use access just to design
the
database).

Also I like to know how to make DECIMAL data in a field,
copied in the same way to a new field in HEXADECIMAL format.

Can anybody help me ?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top