Compare contents of 2 fields.

[Dave Phillabaum]

I have a field content of "1ST SHIFT PICK", this collects
all the lines picked for that day. "1ST SHIFT PACK" uses
the same lines. For example 100338 pick lines are also
100338 pack lines. The information is entered as picklines
and I need to copy the 100338 over as packlines to do
calculations. Any suggestions?

 

[Michel Walsh]

Hi,


Make a backup (or a copy).


UPDATE myTable SET [1ST SHIFT PACK]=[1ST SHIFT PICK] WHERE [1ST SHIFT
PACK] IS NULL



It is a bad idea to work with illegal field name. Use CAPTION for your
presentation, use caption to look nice, but use legal field name, for your
work... and your SQL statements won't be so ugly decorated with [ ] every
where.





Hoping it may help,
Vanderghast, Access MVP