Hi everyone... I'm new to the forum. I have a problem with sorting records in an existing table.
Each record in the table has vibration data in "amplitude" and "phase" fields. The problem is that each record is associated with an "accelerometer" location name. To make matters worse, there is also a "date/time" field.
Example:
date/time accelerometer amplitude phase
12/16/05 alpha 0.05 180
12/16/05 beta 0.10 270
12/16/05 gamma 0.08 135
12/10/05 alpha 0.04 200
12/10/05 beta 0.11 245
12/10/05 gamma 0.15 100
Is there a way to put alpha, beta, and gamma in the same record? So that a form will be able to simultaneously show alpha amplitude, beta amplitude, and gamma amplitude levels for each given date?
Or is there another way to read the existing table in forms?
Thanks for any inputs!
Austin