If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Four Report Problems
comments inline.
"znibk" wrote in message ... Tina, Thanks for your suggestions. I tried them and also went to the website, but was unable to fix my problems, so would you please see if you can see what I did wron from the descriptions I wrote below of what I did. I went to my table and set my Field Name to "Text," you named the field "Text"? uh, before or after you posted? if after, then you misunderstood me (and Duane, and MVP Marshall Barton); don't rename the field - just go to the Lookup tab and change the DisplayControl property to Textbox. that gets rid of the Lookup, as we suggested. on the "LookUp Tab" at the bottom, I chose "ComboBox," Chose my "Table," "Whoes," and set the "Column Width" to "1.5." I opened the table. I have a "Drop Down Arrow", but when I clicked on it, the information from the "Control Source Table," "Whoes," shows the FieldID and the Field Name. I do not have a list of showing whoes expense it is, ie "Joe Green." What did I do wrong? Also, I tried addiing a new name in the Query, but it keeps telling me "You tried to execute a query that does not include the specific expression 'Bank' as part of an aggregate function." I looked in several "Help" sites and could not find out how exactly I'm supposed to add the "FieldName," "Bank" to the new name, "ClCkAmtTot:=sum([ClCkAmt])." So, I unfortunately, don't seem to know how to do what you suggested. here, i've no clue what you're doing. Marsh advised you to "modify the report's record source query to join the table to the clients table and get the client name from there." i left that out of my post, which i shouldn't have, as it's necessary to make the client name field(s) available in the report. And, do you know how to solve Problem 3, the unsitely "0.00" that appear when the no check has been written making the "FieldName," "Client Check Amount" Null. again, you have to change the *name of the control in the report*; presumably it's currently named [Client Check Amount]. as for the expression itself, if you simply want to hide zero values, try =IIf([Client Check Amount] = 0, Null, [Client Check Amount]) I rechecked my Properties for the report and found I had actually chosen the table as my "Control Source." I changed that to query, as I thought I had and Problem 4 went away! i hope you mean that you changed the *RecordSource property of the report* to the query's name, *not* the ControlSource of a control on the report. hth I hope you can help me out further. But, please remember that I am a beginner. "tina" wrote: problems 1 and 2 are caused by the Lookup field you created in the underlying table. recommend you change the field in the table to an "ordinary" Text or Number field. for more information, see http://www.mvps.org/access/lookupfields.htm. problem 3 occurs because the name of the textbox *control* in the report is [Client Check Amount]. in a calculated control, you can't refer to the name of the control itself in the expression, so change the name of the control. problem 4 i didn't really get, sorry. hth "znibk" wrote in message ... Four Report Problems: (So you know my Control Source for the Report, it is a Query.) 1)Sometimes, the FieldID AutoNumber, ie,"45," shows in the Report rather than the entered information, ie, "Client." I pull the Field Name from the Field List into the Report. Incidentally, when I run the Query, "Client" shows, not "45." If I change the text box to a combo box, sometimes the problem is eliminated, sometimes not. But, using a Combo Box leads to another problem: 2) I want to use the Field Name, ie [Whoes] in the "Whoes Footer". Inside the Text Box ="Summary of "&[Whoes] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")" However, I cannot use the Combo Box (needed to view data input) inside the Text Box. 3) I have "0.00" appearing throughout the report. The Default Value is set to "0," with the Standard Format and 2 decimal places. I tried the following two expressions in the field text box and get an Invalid Control Source and Circular Reference message when I try to get out of the text box. I tried =IIF(Is Null([Client Check Amount])," ",[Client Check Amount]) and when that did not work, the comment you'd made earlier about the Null field, I put =IIF(Nz(Client Check Amount],0)," ",[Client Check Amount]) 4) The "Description Footer" and the "Whoes Footer" are appearing in the Report above the Headers at the top of the page! (This is a new problem) I 've compared previous reports, the properties, etc. and can't seem to find the problem. Incidentally, I don't write code and have limited knowledge of expressions or simple calculations. I really hope someone has a lot of patience and can help me out. As in the past, I'll be extremely grateful. |
Thread Tools | |
Display Modes | |
|
|