Giles ,'Chosen'
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
For anyone else's information, I sort of figured it out. My problem was that it won't add it if there is nothing entered in BOTH the fields used. So if I put a 0 in the fields used, the expression will add.
It seems like there should be a cleaner way, but....
Yup. You can't add nulls. What you can do perhaps is set the default value of the field to zero.
Oh. I was thinking it was something like that, but I misunderstood your post so I just got confused.
You can also do this:
=nz([payment1],0)+nz([payment2],0)
The nz(x,y) function will convert x to y if x is null.
eta: Huh. There should be no space after the "["
Sophia, I created a quick Access db with a table with the fields Payment1 and Payment2 and a report that shows each field and the sum of the two. Let me iterate how I set things up and maybe you'll spot something that you missed.
Table tblPayments:
Field: Payment1 Currency, Decimal Places: 0, Default: 0
Field: Payment2 Currency, Decimal Places: 0, Default: 0
Report rptPayments:
Report: Record Source: tblPayments
Text Box:Name: txtPayment1, Control Source: Payment1, Format: Currency,Decimal Places: Auto
Text Box:Name: txtPayment2, Control Source: Payment2, Format: Currency,Decimal Places: Auto
Text Box:Name: txtSumPayments, Control Source: =[Payment1]+[Payment2], Format: Currency,Decimal Places: Auto
HTH
Thanks guys. After using Filemaker for so long, I am finding this really frustrating, and I can't find a good student registration database to look at the inner workings of. (I found when learning Filemaker that looking at sales-type databases didn't seem to help me much)
From Slashdot:
"Google's new IM service is already live. All you need is a Jabber-compatible Instant Messaging client (such as Apple's iChat, or gaim), and a GMail address." This should answer, at least in part, all of the speculation that has been flying around the net over the last couple of days. Stay tuned to Google tomorrow for details.
Huh. I have iChat and a GMail address....
eta: I'm logged in. I just have no one to talk to.
If anyone is online right now, could you see if you can access Eherensteinland.com for me, please?
36 seconds and nothing for me, evil.
Nope.
It appears that DNS never found the address.
Nothing for me either.