Microsoft Access Report problem
Posted 23 May 2006 - 10:02 AM
Posted 28 May 2006 - 02:04 AM
I tried to do what you are attempting to acheive and was unsuccessful.
I am not sure why yet, but there is an alternative.
Try something similar to the following formula in the textbox which is currently getting the error.
=DSum("[Qty]","tblFruit","[Day] = 'Fri'")
In this formula I am calculating the sum of the Qty field in tblFruit where the Day field = Fri
In the crosstab query the type of Fruit is the Row Heading, the Day including Fri is a Column Heading and the value is Qty.
Hope this Helps
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users