Thanks a lot! it solved the problem...

Hi,
I'm having this problem, seems no big deal but I just don't find the way to solve it: I have a field in a form where the user writes a filter criteria and then accepts by pressing a button. The filter works good until the user uses the ' * ' in the search field. In that case no data is shown. The simplest example is when the only filter criteria is *. All the data should be shown, but by this filter method no data at all is shown.
...

Hi, does anyone knows where can I find a good documentation of Access? that means something similar to the documentation documents of Mysql or PostgreSql, where the available SQL functions, operations, ... are shown.

Thanks!

This problem appears whenever a DECIMAL field is used within the pivot table. Solution: convert the field to double. ex: SELECT CDbl(table.fiel d). Where table is the name of your table, field the field of type decimal. After adding that conversion the pivot table should work properly.