selecting multiple vaules from one descriptive field 1

[d44]

One of the tables I am using in the report is called property_descriptor.This table has numerous fields,but the ones in question are 'descriptor' and descriptor_value.

'descriptor' describes information on certain properties and there is a large selection. Below is a few examples of what this field can contain:

e.g. DATB: is Build Date of Building
BEDS: number of bedrooms
WNDS: no of windows....etc

The descriptor_value is the associated value with regards to the descriptor.

e.g. the DATB of certain property,the descriptor_value would be a date field such as. 01/12/1921.

I created a report which has a number of fields,it includes the Date of Build(DATB),which I creatd using the select expert:

property_descriptor = 'DATB'

This rightly gives the build date for certain properties.I am wanting to add in the No. of bedrooms(BEDS)field from property_descriptor,so it will show the Date Of Build AND the Numer of Bedrooms(BEDS)but cant really do it from select expert. I can select the BEDS field on its own or the DATB and retrieve the following value, however I am struggling to find a way to retrieve both, as they are from the same field. Thinking about using the function field and using Select and Where but struggling.

Thanks

 

[rogar]

You need to get two separate records from the property_descriptor table for each property -- one for DATB and another for BEDS. To get both, your record selection formula should include
... ( {property_descriptor.descriptor} = "DATB" OR {property_descriptor.descriptor} = "BEDS" ) ...
Be sure the two conditions joined by "OR" are enclosed in parentheses!

Now group on property id. You can suppress the details and bring down all common property fields to the group footer.
Use formulas or conditional running totals to bring the two descriptor fields into the group footer. Post again if you need help with this.