Search results

A very simple example! A CUSTOMERS table, where data to CITY and STATE fields comes from the related tables CITIES and STATES. I want to define a default value to STATE field, and tried this expression: =DLookUp("[StateName]","[States]","[StateID]=1") But I got an error message: What I'm...

Hi guys! Why the EXPRESSION BUILDER in ACCESS 2013 is showing this (wrong?) sintax for the LEFT function? Left(«string»; «length») I'm studing some books, and in all of them the LEFT function have a COMMA, instead of a semicolon: Left(«string», «length») This causes some problems! In a...