Access query to select records from two tables where fields match

**sumdumgai** · 04-12-2022, 10:01 PM

Hello,

Need help with building an sql query with Excel VBA that would populate a worksheet from fields in the Access database that contained fld1, fld2 and fld3 from tbl1 and fld4, fld5, fld6 from tbl2. The records pulled from tbl1 would have fld1 = 'some text'. The records pulled from tbl2 would have fld4 = fld2

Hope that makes sense.

Thanks for suggestions and help.

**alansidman** · 04-12-2022, 10:57 PM

Would really help if you posted a sample Access DB with limited records and then posted what you want the output to look like in Excel. Once we have that we can write a sql statement for your vba to export the data expected. To upload a sample Access file, you will need to zip it before uploading it.

**sumdumgai** · 04-12-2022, 11:40 PM

Will do. Thanks.

Access query to select records from two tables where fields match

LinkBack

Thread Tools

Rate This Thread

Display

Access query to select records from two tables where fields match

Re: Access query to select records from two tables where fields match

Re: Access query to select records from two tables where fields match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Ms access Code to delete all records in a Tables

Macro to restrict save the records when few fields are not updated in query

Access query criteria to select only fields <8000 or <8000 & one letter

Query Access database and return all records to Excel

Access Query with Calculated Fields Not seen by Excel

Access Table Query to Combine Records

[SOLVED] MS Access Query Identify Friday's records.

Bookmarks

Bookmarks

Posting Permissions