SELECT STATEMENT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Shawn (anonymous_at_discussions.microsoft.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 13:01:11 -0700

I AM TRING TO SELECT CITY AND STATE/PROVINCE FROM MY CUSTOMER TABLE AND RETURN THERE VALUES WHEN MY CUSTOMERS.CUSTOMER ID AND QUOTE .CUSTOMER ID ARE EQUAL. I'M NOT SURE HOW TO DO THIS.
IF ANYONE KNOWS YOU HELP WOULD BE GREATLY APPRECIATED.
THANKS
SHAWN

THIS IS WHAT I HAVE SO FAR.

=(SELECT [CUSTOMER].[CITY],[CUSTOMER].[STATE].PROVINCE FORM [CUSTOMERS] WHERE [CUSTOMERS].[CUSTOMER ID]=[QUOTE].[CUSTOMER ID])

Quantcast