The easy way : Create two new fields (Name and Date) in your OtherAccruals table (or in a copy of it if you really want to keep the table as it was). Then make an update query that will update the two new fields of the table with the values of the constants.
But i doubt it may be useful to have constants as values in a table) GC -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] la part de RAJESH DESAI Envoye : mercredi 8 fevrier 2006 11:58 A : Access1; Access2; Access3 Objet : [ms_access] Add records to table Hi, I have a table called OtherAccruals with two fields i.e. Description and Amount. I have two other values that are constant for all the records i.e. Name and Date. What I want to do is I want to add all the records from the table OtherAccruals to a new table along with two constants i.e. Name and Date. So my new table has 4 fields i.e. Name, Date, Description and Amount. Please help me in this. Thanks & regards, Rajesh Desai --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
