Wednesday, May 26, 2010

Microsoft Access 2007

Sample Microsoft Access Queries :


Query for Replacing "," to ".":
Replace([fath],",",".")

Query for combining 2 fields using if statement:
IIf(Len([PH_R])=6,Replace([PH_O],"-",""),Replace([PH_R],"-",""))