I am trying to formulate a table maker query but am having problems.
I have clone objects for which the In_situ tag appears up to three times:
Clone : MB01A01
and I am trying to display the three values in three columns, instead of
on three separate lines in my table. Is this possible without redefining
my model to have three fields In_situ1, In_situ2 and In_situ3?
I did manage to make a table which displays all three values on one line
BUT which displays them in all six possible orders (and complains many
times about my use of brackets - this might be a bug?). my .def file is
below. However, I have a feeling I am going about it completely the
wrong way. can anybody help?
// Spread sheet definition for the ACeDB software
// Date: 2000-05-23_20:33:12
// %n (%%n in the graphic) are parameter to be given on the command
line in tace
// or by default by the Parameters given in this file
// \%n (%n in the graphic) are substituted by the value of column n at
// Line starting with // are ignored, starting with # are comments
Condition (NOT (\%2))
Condition ((NOT (\%2)) AND (NOT (\%3)))
// End of these definitions