Prev: IIF stmt in Criteria
Next: Control Select Query Output Field Type
From: Gina Whipp on 13 Jan 2010 21:17
Troy,

I too am confused... pehrpas you could outline what Table 1 thru 3 is and
their prospective fields along with what you are tyring to track/accomplish
with this database.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Troy" <Troy(a)discussions.microsoft.com> wrote in message
news:22857EE4-2B90-4AA2-A8CF-55B54444DBBF(a)microsoft.com...
> Table2 was a table made from Table1 from a make a table query so the
> fields
> are the same. The criteria I would like to use is a list of account
> numbers
> from Table3. The field has the same name 'account number' as the other 2
> tables.
>
> I hope I was clearer today. I made my first post at night after a long
> day!
>
>
>
> "John W. Vinson" wrote:
>
>> On Tue, 12 Jan 2010 20:00:01 -0800, Troy <Troy(a)discussions.microsoft.com>
>> wrote:
>>
>> >I need to append data from one table1 to table2 using the field in
>> >table3 as
>> >the criteria. This field in question is 'account number'. How can I
>> >write a
>> >sql statement to accomplish this?
>> >
>>
>> I would GUESS that you would join Table1 to Table3 on [account number],
>> and
>> base your append query on this - but your post is sufficiently vague that
>> this
>> is just speculation. What's in the tables? How are they related? Do you
>> want
>> to append all records in table1 which have a match in table3 or only a
>> subset?
>> --
>>
>> John W. Vinson [MVP]
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: IIF stmt in Criteria
Next: Control Select Query Output Field Type