473,473 Members | 1,843 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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

anoble1
245 New Member
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?

Jan 8 '19 #1
4 1679
twinnyfo
3,653 Recognized Expert Moderator Specialist
You may want to help us out by letting us know what [BD_PRC] and [BD_AVN] represent.
Jan 8 '19 #2
NeoPa
32,556 Recognized Expert Moderator MVP
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.
Jan 9 '19 #3
anoble1
245 New Member
I get that same error when I try and put something under criteria in design.
Jan 9 '19 #4
NeoPa
32,556 Recognized Expert Moderator MVP
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.
Jan 10 '19 #5

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

Similar topics

1
by: Colin | last post by:
I created a macro that starts a filter on a query. The criteria in the query is: Like & "*" The macro is initiated by pressing a command button on the form. This works fine. However, when...
0
by: RJN | last post by:
Hi I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main...
0
by: RJN | last post by:
Hi Sorry for posting this message again. I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be...
0
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the...
0
by: Eduardo78 | last post by:
Ok, I will try to explain first the escenario. I am trying to concatenate 6 fields so they can be in the same row using a cross-tab Report. The thing is that two of these six fields are numeric...
2
by: tjdoss | last post by:
I am trying to display the "Filter by Form" criteria in a Report (that displays the filtered information). I have an unbound textbox with !. as the control source that will give me the Filter itself...
0
denny1824
by: denny1824 | last post by:
I have a crystal report that someone else wrote and already has a Formula Field if Criteria then (Count ({FirstField},{SecondField}) / Count ({FirstField})) When the Criteria is true, this...
9
LeighW
by: LeighW | last post by:
Hi all, I'd like a cover page that shows which filter criteria have been used when creating the report. If this can't be done/ is very hard to implement then I'll leave it be but I thought it...
3
by: Coolbreeze | last post by:
Hi, I have specified form textbox data as query filter criteria,and since then, every time I run the query, the criteria are self duplicating on random lines below the original. Also, there seems to...
5
by: Pierkes | last post by:
Hi, Iám having problems with a criteria in a query. The field is a yes/no field. I have a yes/no field on a form which i can check of uncheck. The field is called . In the query criteria i...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.