Here's the SQL code from in the query:
SELECT [first]+" "+[last] AS name, Clients.ClientID, Clients.First, Clients.Last, Mobility.TotallyIndependent, Mobility.OccassionalAssistance, Mobility.AlwaysAssistance, Mobility.IndependentFlatOnly, Mobility.WalksWith, Mobility.TiresEasy...
Hi there! I have a number of tables in my database. The main table is called Clients with a ClientID set as the primary key (autonumber). I have an number of tables such as Mobility, Communications and Assistive. Each of these tables has the ClientID field in them (set as number) and a ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.