How do I place modules in a cross-tab query?

[timo1999]

I have a module named "ModFractions" that goes through 3 different calculation sub sections (PriceGrouper, FractionGrouper and ConvertFraction) that someone wrote for me. The code looks great, but I don't know how to make this VBA program to work in a cross-tab query. I am trying to add this cross-tab query as a button in an existing form.

The instructions he gave me were:

Crosstab Query:

Row Heading : PriceGrouper ([UMRC])
Column Heading: FractionGrouper (ConvertFraction([UMRP]))
Group by row heading.

I think I need to see a screen shot to figure out how to lay this out in "Design View", or some really clear instructions. Any help would be great!!

tim

 

[ajetrumpet]

The instructions he gave me were:

Crosstab Query:

Row Heading : PriceGrouper ([UMRC])
Column Heading: FractionGrouper (ConvertFraction([UMRP]))
Group by row heading.

try using the CQ wizard to make a query with bogus fields in the row head and column heads. take what the wizard gives you, and substitute what he gave you in the fields that are created. i do that sometimes...

the syntax he gave you is putting field names into procedure arguments to run procedures from the query.