Recent content by FranD

Thanks Again Viola!! Thanks again Wayne. Your help is much appreciated. Fran

One Final Question Now can you tell me how to have the result be displayed as currency?? Thanks again!

Thank you! Thank you.. thank you... thank you...!! It works! ;)

I have the following expression in a Totals query. The error message I'm getting is "This expression is typed incorrectly or is too complicated to be evaluated...." 12MoChgs: DSum("[Charges]","[AR_Rec]","[Month]">=(DateAdd("m",-11,[Forms]![frmAR_RecDialog]![RptMonth]) And...

Using SubForm Values in Code Thanks Wayne, I do have a text field in the form footer of the subform which sums the $ value of each visit. But the problem is, not all data entry people will always check to verify that that text field matches the total amount entered on the Batch form - if the...

I have a form (frmBatchInfo) which captures Charge Batch total information (ie, total $ per batch). This form contains a subform (frmSubFormVisitDetail) which captures the $ per visit. The sum of the $ per visit should equal the total amount entered in the main form. Therefore, I want to...

But where does the "=me.SubForm Control.SubForm Field" go? As you suggested in your first reply, I added a text box to the subform in the form footer and simply calculated a sum of the field I wanted. I named that calculated control "totalRemoved." I then added a text box to the main form...

Thanks Mike, I tried what you suggested, but it's still not working. In the text box on the main form, which refers to the calculated total (in the footer of the subform) I get a "#Name?" error - and in the text box which includes that text box in the grand total calculation I get an "#Error"...

I'm trying to add a calculated control to a form which includes 4 fields from my main form and one from a sub form. I can't figure out how to refer to the sub form control in the expression - here's what I've tried...

I currently have a query that calculates each Department's "Daily Average Charge as follows ([SumOfCharges] / 365). Here's the problem; 2 of the departments are new to the system and don't have 12 months of charges - so we want to divide their total charges by the number of days they've been...

I have a form which contains several controls, including command buttons and one subform. There is quite a bit of code in place to validate the data. Unfortunately, so many fields have been added that I now need to use a tab control with two tabs - I've divided the data entry fields between...

I have a report which is based on a query which uses totals. I want to add the "Comments" field to the report - which of course is a Memo Data type. The only way that I've found to be able to do so, is to select "Last" as the Total Category. However, this will only give me the last comment...

Thanks Steve, Changing the name was indeed the only thing that worked. Are there other Access names that are not good to use as field names? If so, where can I get a list of them? Thanks again. Fran

I put a control on a report that simply concatenates the values of two fields (Division and Section). Here's what I have =Trim([Division]&" - "&[Section]) It returns #Error. I think the problem is the name of the field - "Section". I experimented by replacing the Section field with another...

I have a subform named frmReturnedBatches on a main form named frmCloseBatch. Basically, if a batch is being returned due to problems, the user must enter a date of return. The subform is a tabular form which allows users to enter several reasons for the return into a field named [Problem]...