pivot table with access data

[JulieD]

Hi dave

the way i would approach it is change the access query to a make table query
and then link that table with excel via data / get external data / database
query ... this way you're only dealing with the results of the min function
and not the min function itself.

hope this helps
Cheers
JulieD

 

[dave!!]

i'm not sure if this is a question for the excel folks or the access folks,
but i'll try my luck here first. i used a custom minimum function in access
that i found on the microsoft site to take the minimum of two different
fields within each record (there are 25,000 records or so, so i'd prefer to
take care of finding the minimum in access rather than excel). however,
when i attempt to create a pivot table in excel to summarize the data, i get
an error message that says "Undefined function 'Minimum' in expression."
any ideas about what can be done?

thanks,
dave

 

[dave!!]

thanks for the input, i had a feeling it was going to come down to that.
but as long as i get the pivot table, i guess i really don't care how it's
done.

 

[Debra Dalgleish]

If you're only comparing two fields, you don't need to use a custom
function. For example:

MinValue: IIf([ItemWidth]>[ItemHeight],[ItemHeight],[ItemWidth])