Query data

[Shreekant Patel]

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!

 

[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.