Search results

Thank you for your patience, but I haven't the skill apparently to make the situation clear. To recap: the first money field is the PaymentAmount--let's say $100 is keyed there. By tabbing two or three times one would reach the CourseFee field and enter say $50 - at which point the calculated...

I wonder if there is some kind person, who understanding that answer, will interpret it for me. To which Data Entry Field's properties is he referring? As this is a calculated field, the keyer does not visit that field. The last field input is quite random, depending on the purchases and the...

In an input form called "FrmReceipts" that feeds a table called "TblReceipts", one of the fields is called "OverUnder". This field has as its Control Source a formula: [RunningTtl] - [PaymentAmount]. There are several money fields in the form which must total the payment, so the "OverUnder"...

As I thought, it would be too expensive. If I had to learn several other applications, I'd also be wasting time that might well be spent administering to the members in other ways. I appreciate the response, however, Pat. Cheers!

I realize many features must exist in 2007 and 2010 Access that were not in the 2002-3 version; but can an on line input form be used to a table that feeds a 2003 database in my desktop? If so, what application applies? I'm thinking of having members of a club update their own address/phone...

OK, still learning the terminology. I gather that Fixed Column Headings is a setting that I would have to have used in QryReceipts3 in order to produce all the columns when they were null values in Summary3. I've had to redo the PeteCrosstab.mdb in order to change the tables in it, but I still...

Thanks. Wow! We both work Sundays, too? Course, RegularD, CampaignD, LuncheonG, LuncheonD, Membership, Sales - these would be appropriate titles but meaningless to most - codes R, D, C, G, L, M, & S - (meanings: classroom courses, random donations, campaign donations, luncheon gift expense...

The simple answer, of course is to use Analyze in Excel and simply sum in both directions, which gives me totals by member and by income source. This would be done from Summary3, with the parameter "January 18, 2012". The crosstab query that was called "qryReceipts" had a PayDate by which it...

I don't know about eldest member but still a student. Referring finally back to your CrossTab query, I'm trying to understand it and have used it to demonstrate what I want to accomplish. Query: "Totalling 3" is the cumulation of several attempts. It requires entering the parameter January...

Cheers, vbaInet. I'm 74 this year, but I'll think about upgrading when I get a bit older. BTW, this is just the front end database and it's 92 mb. I'd never have used a crosstab query, however. Appreciated the lesson.

OK, thanks for the help. I copied it to a flash drive and opened it. Not the way I like doing it though. Still, I'll keep it in case I have a situation needing a cross-tab query. I still don't use SQL or VB. Still have 2002 version also. Cheers, mate.

I downloaded that mdb file to my downloads folder, but Access says it is "..located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location. OK"

My objective was to parallel what I've typed in a spreadsheet for you. Except that in an Access Report, "Null" is used instead of " " in Excel. In Excel, the totals in column I add without regard for " " values; but in Access, you need the nz expression to turn the Null values back to zero...

The data source is the Table. Each record in the table has both a Code and an amount paid. If the Code is "L" it is a Luncheon Ticket purchase (usually $50.00) of which Canada Revenue counts $20.00 as tax-deductible. If instead the Code is "M" it is a Membership fee. If "R", it is a Course...

While I was waiting I tried an alternate method that worked. I added a (non displayed) field called "LuncheonTot" and used that field in the Totalling expression - removing the 40% and 60% amounts. I guess the nz wrap can't handle it the way I presented it. Thanks for your response, though.

I doubt the screen print is of any use. Here is the formula summary: Luncheon field - =IIf([code]="L",[amount]*0.4,Null) NonDed field - =IIf([code]="L",[amount]*0.6,Null) The Data Source has a text field called "code" with a single letter in it, that designates the purpose of the "amount"...

I'm sorry, vba but the problem is that the Total formula only shows the 2nd field amount when it should show the total of the first two field amounts, when both have a calculated value. Here's a screen print of the design view of the report. Thanks for your response.

My Receipts report has seven currency fields, each of which uses a variation on =IIf([code]="A",[Amount]*0.4,Null) The Total field has the formula: nz([DonationA1],0+nz([DonationA2],0+nz([DonationB],0))) (shortened from seven fields). All but one of the six fields is usually Null, (depending on...

By the way, I used to summer (as a kid) at Weston-Super-Mare. Cheers!

OK, now I see your revision "currency" - yes, it works fine. Have a great day!