MajP, as is typical of all users I'm under a deadline so that's what I'm going to do. Good thing is while I need to create 56 different reports, they all are the same except for the category.
LOL, it probably could be attributed to bad table design; however, these database are over 40 years old, for you young guys its a lifetime.
Unfortunately, I have to deal with what I have.
In a previous comment, think of a Operating Budget. There are multiple items in a budget, in our case 56...
Thanks, sorry for being so dense, but how to I find it programatically? BTW just using the TextExp.controlsource = "AdminFee" I get a Duplication Output Alias '_Agg434'. error. I'm back to where i started. LOL
Thanks again
Mintjulep, our financial guy just wants a list of all the projects along with the admin fee listed. Next time he may want the Mgmtfee. I thought it would be easier to write just one report and use an unbound textbox to display his selection. I really didn't want to write 56 reports all the same.
in my report I have an unbound textbox = txtExp
In a case statement I have if Case = 1 then txtexp = AdminFee
What am I missing? I get an error message Run-time error 2427 You entered an expression that has no value
Those actually are my field names. AdminFee, LegalFee, MgmtFee. If you think of a operating budget for businesses, in this case multiple apartment complexes.
So:
Property Name AdminFee LegalFee MgmtFee
Skips Apt $30 $50 $20
Daves Apt $25 $60 $30
Franks...
I've tried looking through the threads and found a few that were close. I have a query that contain multiple records that have multiple expense field such as AdminFee, LegalFee, MgmtFee etc. (there are 56 total). When I run the report if the user chooses just to see the AdminFee that's all I...
I reran the query and did what you suggested and unfortunately/fortunately there are records. I had the undata event already written into code. Thanks again.
Thanks for the suggestion. I'll try that although I'm not sure if that is the case. I am linked to an AS400 mainframe using ODBC driver interface. There are multiple records. It just seems unusual that I can do the ME.[field name} and it shows but can't find the field when I run the report...
I am trying to write a report which is based upon a selection from the user. When I run the report I get the message "Microsoft can't find field "" referred to in your expression". The field is contained within the underlying query. Additionally, when I type ME. the field name is shown.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.