select field button

[awake2424]

On an access 2010 form if there are 5 fields (Number,Address,Gender,Age,Date). Is it possible to use a button to export 3 fields (Number,Age,Date) to an excel spreadsheet (Master) and place them in a specific worksheet (Info)? Thanks

 

[John Big Booty]

Build a query that collects the data you wish to export to Excel and then use the code here to export that data to Excel.