Yup. You can't add nulls. What you can do perhaps is set the default value of the field to zero.
Fred: So you don't worry that it's possible for someone to send out a biological or electronic trigger that effectively overrides your own sense of ideals and values and replaces them with an alternative coercive agenda that reduces you to a mindless meat puppet? Shopkeeper: Wow. People used to think that I was paranoid.
'Time Bomb'
Buffistechnology 2: You Made Her So She Growls?
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!
DXMachina - Aug 23, 2005 11:48:07 am PDT #4162 of 10003
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
tommyrot - Aug 23, 2005 11:49:17 am PDT #4163 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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 "["
Eddie - Aug 23, 2005 11:58:25 am PDT #4164 of 10003
Your tag here.
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
Sophia Brooks - Aug 23, 2005 12:01:16 pm PDT #4165 of 10003
Cats to become a rabbit should gather immediately now here
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)
tommyrot - Aug 23, 2005 2:25:31 pm PDT #4166 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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.
evil jimi - Aug 23, 2005 2:41:05 pm PDT #4167 of 10003
Lurching from one disaster to the next.
If anyone is online right now, could you see if you can access Eherensteinland.com for me, please?
§ ita § - Aug 23, 2005 2:42:17 pm PDT #4168 of 10003
Well not canonically, no, but this is transformative fiction.
36 seconds and nothing for me, evil.
tommyrot - Aug 23, 2005 2:42:57 pm PDT #4169 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Nope.
It appears that DNS never found the address.
Jon B. - Aug 23, 2005 2:44:16 pm PDT #4170 of 10003
A turkey in every toilet -- only in America!
Nothing for me either.
evil jimi - Aug 23, 2005 2:44:39 pm PDT #4171 of 10003
Lurching from one disaster to the next.
"Great"! Thanks tommy and ita. I just needed to know it wasn't just me who couldn't access the site. Now I know the problem is at the server end and not here at my end of the journey.
eta: and thanks also, Jon