the two tables? If Table-B has a Division field, you can perhaps run an
update query:
UPDATE [Table-B]
SET Division =
(SELECT Division
FROM [Table-A]
WHERE [Table-A].District = [Table-B].District)
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Abu Bakar Chowdhury
Sent: Thursday, April 20, 2006 5:09 AM
To: [email protected]
Subject: [ms_access] SQL Query
Hello
I hv a problem.
I have two tables.
Table-A Table-B
Division District
District Thana
Thana Address
Now I want to add division field in table-B if the
table-a.District=table-b.district.
Pls help
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
