Exporting data from Access To Excel (6 Months + Only)

Hi Guys,

I have a database with nearly 50,000 records in including sub forms that are connected to the main form, what I want to be able to do is, have a button on my switchboard that when clicked with export any records over 6 months into an Excel Spread Sheet. Is this possible at all and if so, How do I do it.

I only have basic knowlege of access so simple explanation is needed, sorry xx

I found this code, can anyone tell me if it is the correct one to use, I also need to know how to create the query for the button, I can do basic queries but I need the button to on export anything that is 6 months +.

Please Login or Register  to view this content.

I would appricate someones help, you may need to be patient with me lol

Shaxx
xx