[Q] Field formatting. How do you split one field to four.
From: <msoppitt_at_eastman.co.uk>
Date: 1996/08/07
Message-ID: <839418024.24575.0_at_eastman.demon.co.uk>#1/1
Date: 1996/08/07
Message-ID: <839418024.24575.0_at_eastman.demon.co.uk>#1/1
Forms 4.5
Any suggestions would be more than appreciated.
I have four fields, value 99 each and go to make one database field of
ie 01||03 ||01||05 each set of two figures represent a description
from an Lov (ie 4 diferent lovs make a discription that = A,B,C,D).
How do i read the 8 numeric field from the database (ie on query) and
split it into the four fields.
I tried using a hidden box over the four 99 fields which would display
for query mode and hide for insert but this is a bit messy.