Forum Discussion
MsAccess Help Expressions and property
Hello Access community!
I hope you are doing well, I have this report where someone else made the program using access and he is no longer with us, I have this field as shown in the picture below:
where I am trying to find the calculations that is turning that out.
and when I look at it in the control source it is this buy cost that is there as well so now am not sure where the calculations of this is stored.
this is an expression builder and am a msaccess noob so I dont know how to figure it out, help would be appreciated it!
- It looks like it is not a calculated field on the report. So there is no expression. The field comes directly from the recordsource of the report.
- is there a way to find that record source? I look at the excel that is being uploaded for this report and it does not have that field in the excel so it must be calculated somewhere right?
- What is problem with this control. Calculation is inside query and you are seeing just field name. Are you getting any error? Go to report data source then find the query name. See Query design view or SQL view for details of query definition.
Harun24HR
I found the query but no luck here either- Can you upload a copy of your database?
Harun24HR
sorry if this is a noob question to your answer as I dont know anything about access, I am trying to find the calculations that the previous guy used there in that fieldis this where you meant? because I cant find it here either
