Search results

I am at the last phase of producing an extensive analysis report. The last calculation I need to the query QryCom_CalculationFinal gives me the "Too many fields defined" error. I have verified that "Ps_Score" calculation push the system into overload, as QryComp_CalculationFinalPrt01 without...

JC, Thanks so much for your continued help with my issues. I realize I should have given more of the whole picture. While the scope of this current effort is simply to obtain an average of the BS values >0. Zero/null fields are not to influence the outcome. This calculation will then be...

CJ, Thanks. It is most helpful to understand that I need to use the actual calculation in the query as apposed to its name. Since the first calculation was only the first part of the actual calculation I thought I needed and has not other use, I could delete these calculations. With being...

CJ, Thanks for looking into may issue. I have accomplished what I understood you suggested. I guess I went wrong somewhere. I am still getting the same error. I have attached a snap shoot showing the error and the revised database. Would let me know what I am still doing wrong? Timothy

I cannot figure out why I get "query does not include specified expression" See Attached CalculationError.PDF and attached zip database Query: Qry01BSTo#. This is just the first step in a multi calculation endeavor. Any suggest about modify this data base to true relational data base will...

Bill and All, I have attached the data base with my attempted reports. I am trying to show everything in the Form, "FQTotal" on the report, "RQFormTotal". I have not been able to get the report to print information from each tab. It only prints the selected Tab. Ultimately, I will want to...

There was not one. I was so frustrated as I tried to shrink the data base to below 2 k, I ended up deleting all I had run from small sample. I can only Zip at home presently. I hope to send a new zip with the report I am having trouble with from home this evening. Thanks so much for looking...

Let me start by saying thanks to for all the help in the past. I am not trying to produce a report that has in access of a 100 fields many of which are memo for each record. I keep bumping up against a what seem to be a 22" limit, even thought I am trying to generate multiple 8.55 11 sheet...

Billmye, Thanks for your quick response. This will move me into a whole new section of Access I have not yet used. I guess it is time to move ahead. I will also have to learn how to automate the append table process. Thanks for your help. Timothy

First thanks for your help in the past. It is greatly appreciated and allowed me to move forward. Quick summary (See Attached) Data is stored in 11 tables each with matching primary key. Each table has in the range of 20 fields of which only numbered data type are being used in...

Bob, I just go back to the office. Thanks so much for your suggestions. I will begin to implement your suggestions. I hope to get back to you with success. Timothy

All, I have been wondering why I have not heard back from anyone. Now I see my last two post are not in the record. ________ I am unable to understand why The "Total" field of Query "QT01BSZ" is giving me totals using the "and" arrgument instead of the simple "+" requested. _________ Any...

JHB, I saved the Excel file to 97/2003 format and did not zip. Let me know if you can open it now. Thanks again for looking into this for me. Timothy

JHB, Attached find PSAssm file. It compacted to 1.7MB. I anciously await any ideas. Again thanks for your help. Timothy

JHB, Thanks for your reply. I only have Access 2007 at home. The file I wanted to attached is in 2010 and compresses only to 3 MB. An Excel sheet is attached. The Excel sheet is only a form but it shows where I am trying to go with Access. I have not been able to accomplish the first step...

Bob, Thanks for your quick reply. I will study about normalizing this weekend. I could attach the data base if I knew how in this forum. Presently the complete file is only 30KB. Because of ignorance, I have 11 tables linked by a common ID. All linked tables are in a one to one...

I, it seems, am a beginner even though I have been working with Access for years. Today's Issue: Within 11 tables of number fields I want to average results found in fields with greater than zero values. Each record of each table may have up to 10 potential fields to be averaged. How do I...