Re: [MSAccessProfessionals] Basing an Expression off of Another Expression?

Hi Crystal, 

Do any of these databases allow the snow persons to throw snowballs at another snow person?   I like to have animation in my reports.  And I want them to yell, "Heads up!"

Happy Holidays.

David

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Tuesday, December 13, 2022 2:48 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Basing an Expression off of Another Expression?

 

Welcome, Penny

adding on to Duane's suggestion. If you're reporting, another suggestion is:

(AddressComplete + " ") & (StreetNumber + " ") & (StreetDirection + " ") & StreetName

... that will show whatever is there ... and maybe it needs fixin' ;)

* removed spaces in fieldnames and made ProperCase ... as they should also be in the table design too

* also took advantage of Null Propagation

kind regards,
crystal

On 12/13/2022 12:31 PM, Duane Hookom wrote:

There is a Nz() function that might work:

New Address: Nz(ADDR, [Address Complete])

If ADDR is null then use the other field.

Duane

Price, Penny E. - DSD Admin Support Asst III



Hi Everyone!

 

I am wanting to update one of my databases to change how the address is input ….initially I had several fields that I used to signify an address. There was the Street Number (2244), the Street Direction (W), And the Street Name (Colfax Ave).  Since I often needed the entire address to refer to, I created a concatenated address as an Expression and named it ADDR.

 

Although hitting that Enter Key between the original fields doesn't slow my roll any, it does so for other potential users.  I created a New Field named ADDRESS COMPLETE into which the entire address can be entered.  HOWEVER: I still want to have one place that contains the entire address whether it was entered the old way (the 3 separate Fields) or the new way (into the New Field named  ADDRESS COMPLETE).

 

Is there a way to build a New Expression (NEW ADDR), based off whether the Old Expression (ADDR), has an address in it or not. If any of the previously mentioned concatenated fields are filled out, then this expression  should give the info (ADDR).,  otherwise the expression should show the results from the New Field (ADDRESS COMPLETE).   I've tried various iterations of the following but I always get an error.  Is this doable? Thanks Everybody and Happy Holidays to All!

 

NEW ADDRESS: IIf(IsNull([ADDR]),[[ADDRESS COMPLETE]),[ADDR]