S
slowly learning
I have a table that is storing information from electrical panels. In my
table there is a column for circuit phase and another for actual amp load, in
the fields under the phase column the entries are either A, B, C, AB, BC, CA
or ABC depending on how many poles and where in the panel the individual
circuit lies. Where I am having trouble is in my query there are three
different amperage fields; one each for A Phase, B Phase and C Phase, if an
item is listed in table as only A phase then it should only show actual amp
load in the A phase of the query and so forth for B and C. if an item shows
to be on BC phase in the table then the entry for actual amp load should show
up in both the B and C phase columns in the query. I have tried If
statements and Like with wildcrads with no luck getting the correct amperage
readings into the correct columns in the query I've gottem either no records
at all or all table entries into all query fields regardless of phasing. any
help would be much appreciated.
table there is a column for circuit phase and another for actual amp load, in
the fields under the phase column the entries are either A, B, C, AB, BC, CA
or ABC depending on how many poles and where in the panel the individual
circuit lies. Where I am having trouble is in my query there are three
different amperage fields; one each for A Phase, B Phase and C Phase, if an
item is listed in table as only A phase then it should only show actual amp
load in the A phase of the query and so forth for B and C. if an item shows
to be on BC phase in the table then the entry for actual amp load should show
up in both the B and C phase columns in the query. I have tried If
statements and Like with wildcrads with no luck getting the correct amperage
readings into the correct columns in the query I've gottem either no records
at all or all table entries into all query fields regardless of phasing. any
help would be much appreciated.