Add another column in query

[Anna]

Hi: Can any one please tell me how to add one more column
"user_view.User_Office_Location" in the query.
Thanks.

dbtr_view.assign_id=user_view.user_id

------
select distinct(dbtr_view.debtor_id),
dbtr_view.Next_Contact_Date,debt.clt_id, clt_ref_no, name1, name2,
list_date, cur_bal, assign_id, dbtr_view.status_code,
dbtr_view.status_date, dbtr_view.next_contact_date From dm.dbtr_view
left outer join dm.debt on (debt.debt_id = dbtr_view.debtor_id,0) left
outer join dm.pmt on (dbtr_view.debtor_id = pmt.debtor_id,0) where
dbtr_view.assign_id in ('OXF') and list_date between '2007-02-06' and
'2007-02-13' and (debt.clt_id like 'CINC01' ) and
dbtr_view.status_code < '400'

 

[Jeff Boyce]

Anna

Following the "SELECT" keyword, add your new column and a comma and a space.
Take a look at how " name1, name2, " appear and make your new column work
the same way.

Or you could just use the design view and add the field to the query design
grid.

Regards

Jeff Boyce
Microsoft Office/Access MVP