I suppose you've already been told/read that MVF's are evil? This is a post that might not get a lot of support because
a) nobody here who's fairly knowledgeable would use them thus the chances of knowing how to solve the problem is slim
b) anyone who would use them doesn't know enough to solve your problem
So, I can only offer a shot in the dark because I've posted on how to get values from queries that act on table MVF's, but never for charting.
If you can get the values listed out in a query by using the .value property of a mvf, then you might succeed. So if the query field is Customer (which holds the mvf value) then make it Customer.Value, or if it's for criteria, Customer.Value = "Acme"
Last edited by Micron; 01-10-2017 at 06:17 PM.
- "doesn't work" doesn't help. Post error #s & text, if known.
- Use code tags for code/sql; show where errors occur
Make all suggested changes in copies of your database or to its objects.