176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Microsoft Access problem with queries
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Mar 23, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Mar 22, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Hi,

I have a training database in Microsoft Access for staff.

I am trying to create a report which shows mandatory training not been renewed.

At the moment the queries returns the following fields:

- ID
- First Name
- Last Name
- JobTitle
- Department
- Course Title
- Taken On
- Date of Refresh


Taken On and Date of Refresh are date fields

Two records for the same staff member can have the same course title and different dates for taken on and date of refresh for example:

Name: John Smith

Course title: Consent
Taken on: 15/02/2007
Date of Refresh: 15/02/2010

Course title: Consent
Taken on: 02/06/2010
Date of refresh: 02/06/2013

Another record for the staff member could have:

Course title: Health and Safety
Taken on: 20/11/2007
Date of refresh: 20/11/2010

I need a query that will look at each staff member records for example john smith, and if date of refresh not been renewed for example health and safety then show this in report and ...

Sign in or Register to see more

Job ID: 39371929
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
I have 28 years experience designing & building database and other applications in Office VBA and Visual Studio VB.NET. I'm skilled at creating...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 39945554  |  Submitted: Apr 5, 2013 20:06 ET 
Proposal SEALED

 Pakistan  |  
Expert in Microsoft Access Database development. VBA for Access and Excel. Having development experience of ten years for building applications for...
6
  |  
 4.9   |  Private   |  17 Jobs
Bid ID: 39432851  |  Submitted: Mar 24, 2013 11:22 ET 
Proposal SEALED

 United States  |  
My area of expertise is in data analysis and mining. I have worked in a Microsoft environment for the last 20 years. Spent about 10 years...
6
  |  
 5.0   |  $849 Earnings   |  6 Jobs
Bid ID: 39404753  |  Submitted: Mar 23, 2013 10:00 ET 
Proposal SEALED

Danang Nurdiansyah      
Danang Nurdiansyah's identity has been verified.  Learn More
 Indonesia
I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL,...
1
  |  
 2.2   |  $27 Earnings   |  0 Jobs
Bid ID: 39395170  |  Submitted: Mar 23, 2013 02:04 ET 
Proposal SEALED

Michael B.      
Michael B.'s identity has been verified.  Learn More
 United States
For the past twenty-two years I have been involved in the design, development, installation, and implementation of enterprise wide applications as...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 39393535  |  Submitted: Mar 23, 2013 00:45 ET 
Proposal SEALED

 United States  |  
DBA / BI developer at Fortune 500 company in Florida
4
  |  
 5.0   |  $1,070 Earnings   |  1 Jobs
Bid ID: 39389260  |  Submitted: Mar 22, 2013 20:20 ET 
Proposal SEALED

 Romania  |  
I'm a professional full-time programmer, with 15 years corporate experience and a strong professional background maintained by a significant...
9
  |  
 5.0   |  Private   |  50 Jobs   |  3 verified credential(s)
Bid ID: 39385565  |  Submitted: Mar 22, 2013 17:13 ET 
Proposal SEALED

 United States  |  
Multi Skills have experience in Medical Coding and Translation. 5 Years Experience in Testing Apps both Manual and Automation. Have 2 years...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39384121  |  Submitted: Mar 22, 2013 16:18 ET 
Proposal SEALED

 India
Having 15 yrs experience as professional and have the capability to take full responsibility on my shoulder for any project work.Try to maintain...
5
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39381165  |  Submitted: Mar 22, 2013 14:48 ET 
Proposal SEALED

 United Kingdom  |  
Winner
I am certified in various technologies. Have experience installing, configuring, maintaining databases, websites, surveillance systems, CCTV...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39380237  |  Submitted: Mar 22, 2013 14:21 ET 
Delivery
Within 1 day
$21.92

 Romania  |  
I have more that 10 years working as a Database Specialist (programming), T-SQL becoming the main tool for solving all business request related to...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39379169  |  Submitted: Mar 22, 2013 13:51 ET 
Proposal SEALED

 Cyprus  |  
I have lot of experience in various IT/Software Projects such as Information System Design, Development, Database Administration, Web Development....
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 39377986  |  Submitted: Mar 22, 2013 13:23 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »