Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query data

Discussion in 'Information Technology' started by Shreekant Patel, Jul 28, 2006.

Tags:
  1. Shreekant Patel

    Shreekant Patel
    Expand Collapse
    Guest

    Hello,

    I am hoping for someone to help me out with a query I need to run on my
    MDB.


    I have one master table that collects all the information called ALLBS.
    There are other relevant tables that the ALLBS relates to get
    information from.

    Currently when I export data from the ALLBS table, to excel it carrys
    forward the numerical values that represent the record from another
    table. I think an example would explain this best

    There are quite a few fields that are in the ALLBS so I will simply use
    the ones which are giving me a problem

    ALLBS:
    BSID PK
    EAssetType number
    AssetLocationType
    ParapetType number
    LocationID number
    LineID number



    Related tables:

    tblAssetLocType
    AssetLocID PK
    AssetLocType Text

    tblLine
    LineID PK
    Line Text

    tblLocations
    LocationID PK
    LineID Number
    LocationType text
    LCS text
    LCSDesc text
    AssetLocationTypeID num

    AssetLocationTypeID relating to tblAssetLocType>AssetLocType.

    tblParapetType
    ParapetID PK
    ParapetType Text

    In my ALLBS table this is how the data gets stored:

    BSID EllipseAssetType AssetLoctype Direction ParapetType
    LocationID Line
    1 FootBridge - NA
    3 00023456 2

    The values 3 under parapet type represents "STEEL" from tblParapetType
    and value 2 under Line represents "CENTRAL" from tblLine.

    Attention! 1
    I need these numerical values replaced when i run a query so i can
    export the data. How can i achieve this?

    Your help would be greatly appreciated.

    Thanks
    Shreekant
    Have an awesome day!
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Sounds like your query has only one table showing. You must add all the
    needed tables; join them properly; and pull down the required fields into the
    QBE grid.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "Shreekant Patel" wrote:

    > Hello,
    >
    > I am hoping for someone to help me out with a query I need to run on my
    > MDB.
    >
    >
    > I have one master table that collects all the information called ALLBS.
    > There are other relevant tables that the ALLBS relates to get
    > information from.
    >
    > Currently when I export data from the ALLBS table, to excel it carrys
    > forward the numerical values that represent the record from another
    > table. I think an example would explain this best
    >
    > There are quite a few fields that are in the ALLBS so I will simply use
    > the ones which are giving me a problem
    >
    > ALLBS:
    > BSID PK
    > EAssetType number
    > AssetLocationType
    > ParapetType number
    > LocationID number
    > LineID number
    >
    >
    >
    > Related tables:
    >
    > tblAssetLocType
    > AssetLocID PK
    > AssetLocType Text
    >
    > tblLine
    > LineID PK
    > Line Text
    >
    > tblLocations
    > LocationID PK
    > LineID Number
    > LocationType text
    > LCS text
    > LCSDesc text
    > AssetLocationTypeID num
    >
    > AssetLocationTypeID relating to tblAssetLocType>AssetLocType.
    >
    > tblParapetType
    > ParapetID PK
    > ParapetType Text
    >
    > In my ALLBS table this is how the data gets stored:
    >
    > BSID EllipseAssetType AssetLoctype Direction ParapetType
    > LocationID Line
    > 1 FootBridge - NA
    > 3 00023456 2
    >
    > The values 3 under parapet type represents "STEEL" from tblParapetType
    > and value 2 under Line represents "CENTRAL" from tblLine.
    >
    > Attention! 1
    > I need these numerical values replaced when i run a query so i can
    > export the data. How can i achieve this?
    >
    > Your help would be greatly appreciated.
    >
    > Thanks
    > Shreekant
    > Have an awesome day!
    >
    >
     

Share This Page