424,066 Members | 2,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,066 IT Pros & Developers. It's quick & easy.

Possible to filter criteria where a custom formula is in the Field in the query?

P: 220
I have a query that I am calculating margin. I put this in the "Field:"
Expand|Select|Wrap|Line Numbers
  1. Margin: ([QS36F_PARTSSERV]![Sell]-[QS36F_PARTSSERV]![Cost])/[QS36F_PARTSSERV]![Sell]
When I put anything in the criteria I get: ....Data conversion or data mapping error. I guess i need to filter in the Field with the formula up there? See attachment? I wanted to show anything > than 24.4 or 0.244. Help?

1 Week Ago #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 2,780
You may want to help us out by letting us know what [BD_PRC] and [BD_AVN] represent.
1 Week Ago #2

Expert Mod 15k+
P: 31,170
Are you saying you never get the same errors when the criteria isn't there?

When criteria are included the formula is resolved at an earlier point in the processing of the query. It may be that what is in your formula isn't available at that point in the process.
1 Week Ago #3

P: 220
I get that same error when I try and put something under criteria in design.
1 Week Ago #4

Expert Mod 15k+
P: 31,170
That wasn't actually the question, but never mind.

I suspect my earlier post should point you to where you need to look. We can't help at this point as you haven't shared where the data comes from, or indeed the whole query.

You should have enough to understand why it's happening though.
1 Week Ago #5

Post your reply

Sign in to post your reply or Sign up for a free account.