Search results for query: *

MajP, thanks for the code. I'm going to give that a try. Since I'm under deadline I went another route, very messy but it's gets the job done for now.

Thanks MajP, I'd appreciate it. MajP and Andrezejek, I'll try both suggestions.

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.

Mintjulep, I don't think the issue is in the SQL or query but is in the report. You are correct I am trying just to display just the AdminFee.

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.