Using MS Access/Macros

Advertisement

Expert: Geoff - 6/9/2009


Question
Im looking to make a macro that will pull out all 5 entries for the week and pick out The particular employee then put it into a table.  Can you help me?
Using MS Access 2007

Answer
Nick,

A query could do it,but you don't give much information about you tables, so difficult to be helpful....

Something like this would do the trick:

INSERT INTO tblTarget(EmployeeName)
SELECT DISTINCT EmployeeName FROM tblTimeClock
WHERE DateTime BETWEEN #[Enter Start Date]# AND #[Enter End Date]#;

I hope this helps

Kind regards

Geoff :-)

Using MS Access

All Answers

Answers by Expert:

Ask Experts

Volunteer

Geoff

Expertise

I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.

See my website for example apps and downloads

Experience

I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.

Commercial database design and development work undertaken.

©2012 About.com, a part of The New York Times Company. All rights reserved.