QUERYS

T

tye

Hi,

can u help me.

i have two tables one with all the sales that where made
on WHAT DATE WITH THE TIME E.G 20040406205652 This is the
format the date is in.

the second table is a link from the main campagin table
that has all the customer details in.

what i need to do is the following
1. select the data, the sale is form e.g 20040101* then in
both table it was got spare1 and spare2.
2. what i have done is linked by tables with field that is
phonenumber.

3. is there a way that i can get one date and change of
the codes that need change are only spare1 and spare2.
in tblContracts the codes in spare1 and spare2 are wrong.
The right codes are in dbo_Campaign BUT thier are more
then one codes we have about 6 different codes at this
time.
How can i do this

3. the code that are in partone table under spare1 and
spare2 do be undata in tblcontracts under spare1 and two
spare2.
can you help
First Query
SELECT tblContracts.TransactionID, tblContracts.HomePhone,
dbo_Campaign.Spare1, dbo_Campaign.Spare2 INTO Partone
FROM tblContracts INNER JOIN dbo_Campaign ON
tblContracts.HomePhone = dbo_Campaign.PhoneNum;

Second Query
SELECT Left([TransactionID],8) AS [Date],
tblContracts.HomePhone, dbo_Campaign.Spare1,
dbo_Campaign.Spare2 INTO Partone
FROM tblContracts INNER JOIN dbo_Campaign ON
tblContracts.HomePhone = dbo_Campaign.PhoneNum
WHERE (((Left([TransactionID],8)) Like ([Enter Date -
YYYYMMDD] & "*") Or (Left([TransactionID],8)) Like
([Enter
Date - YYYYMMDD] & "*")));

HELP!!!!!!!!!!!!!!!
 
Top