Frond Production Count

[c8tz]

Hi - need some assistance here ..

I have a table that has a date column, number of fronds, palm number,
block number

The date is for when the recording date of number of fronds for each
palm is done.

I would like to create a query that picks up a palm (there can be up
to 16 palms in a block) in a block and calculate the avg of frond
between the date of the first recording and the second recording.

Do I use a cross tab query or a normal query -

Please help

thanks,

 

[John W. Vinson]

Hi - need some assistance here ..

I have a table that has a date column, number of fronds, palm number,
block number

The date is for when the recording date of number of fronds for each
palm is done.

I would like to create a query that picks up a palm (there can be up
to 16 palms in a block) in a block and calculate the avg of frond
between the date of the first recording and the second recording.

Do I use a cross tab query or a normal query -

Just depends on how you want the results displayed. A Totals query, Group By
Block, Avg of [Number of Fronds], using the Where "totals" operation on the
date column and a criterion like BETWEEN [Enter start date:] AND [Enter end
date:] will give you the results in a "tall thin" recordset, one row per
block.

A Crosstab will give you a block of results, with (say) Block Number across
the top and date down the side.

John W. Vinson [MVP]