Re: Field Relationships

Use a formula to get the circuitID.
Assumptions:
-- There is always a dash at the end of the circuit number
-- The dash at the end of the circuit number is the first dash in the string
-- The circuit number is always 5 characters long

CircuitID: MID(Str_ID,Instr(1,Str_ID,"-")-5,5)

You can use this generated circuit number to join the tables together. It can be
done directly in the query,
or you can build separate queries for each table with this calculated value and
join them,
or you can add a field to each table and use the formula to populate the new
field using an update query.



Nadia wrote:
>
> Hello and thank you in advance to anyone who may assist me.
> This will be the first of a few posts I will be making.
>
> I am trying to query data between 4 tables (Line, Load, Fuse, Recloser).
>
> The fields I'm attempting to join are:
> Line!STR_ID
> Load!NAME
> Fuse!STR_ID
> Recloser!STR_ID
>
> My problem is that no exact unique identifier field exists between the
> tables in these fields. But there is a five-digit circuit number buried
> within each these fields that match up. i.e. STR_ID= "Z12345-7788996" the
> circuit number is always before the hyphen so in this case it is "12345".
>
> The proceeding numbers vary within the fields along with the leading
> alphabetic character. Is there any possible way to join these tables so I
> may extract data?
>
> Or...
> The only way I have thought possible so far is to make another field within
> each table. By doing this I'd copy and paste each field listed above into
> Excel and find a way to grab the circuit number out of the data. I know
> there is a way to do this as well but I can't remember.
>
> Please help ASAP!
>
> Thanks.
>
> --
> Nadia
.

Relevant Pages

  • Re: Switching Algebra and CIrcuit Design for the SIght Impaired (Newbie)?
    ... I have no need for simulation though it may be necessary in some other ... > They used text characcters that approximate the circuit ... speech the main problem is that it doesn't understand the syntax used. ... greater than dash dash dash greater than vertical line dash dash is a ...
    (sci.electronics.misc)
  • Finding/fixing short in DOOR OPEN light circuit
    ... I have a short somewhere in the circuit that activates the door open ... light on the dash that I believe is the cause of a dead battery. ... at author's request ...
    (alt.autos.toyota)
  • Re: Finding/fixing short in DOOR OPEN light circuit
    ... >I have a short somewhere in the circuit that activates the door open ... > light on the dash that I believe is the cause of a dead battery. ... Start with the switches at each door. ...
    (alt.autos.toyota)
  • Re: Field Relationships
    ... Is there any way I may adjust this if the circuit number is not always five ... It can vary from 3 to 5 digits. ... dash proceeding the circuit number. ...
    (microsoft.public.access.modulesdaovba)
  • Re: confusing criteria
    ... easier to query in the long run. ... Circuit table: ... table there is a column for circuit phase and another for actual amp ... the fields under the phase column the entries are either A, B, C, AB, ...
    (microsoft.public.access.queries)