Simple Auto populate to an Append Query Question 1

[iuianj07]

Hello guys,

I need help, I have a simple append query:

INSERT INTO tblLoans (LoanNumber)
SELECT tblCopy.LoanNumber
FROM tblCopy;

my question though is, in tblLoans there is a RushRequest field... any what I want to do is that whenever I run the append query above... the RushRequest field in tblLoans will all default to "No" for the new records appended... I only know how to set to default to "No" when creating new records (via form properties) but I don't know how to default to "No" for appended records...

Any help is greatly appreciated...

thanks...

 

[PHV]

INSERT INTO tblLoans (LoanNumber,RushRequest)
SELECT LoanNumber, False AS A
FROM tblCopy

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[iuianj07]

Hello,

I ran the query you posted, and instead of "No" it is returning 0 for RushRequest field...

Thanks

 

[PHV]

If RushRequest is text
INSERT INTO tblLoans (LoanNumber,RushRequest)
SELECT LoanNumber, 'No' AS A
FROM tblCopy

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[iuianj07]

Thanks PHV,

That did the trick... forgot to mention that it is text... because possible data in there are either No, SameDayRush and 1-5DayRush.

Thanks