+- +-

User

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

Stats

Members
Total Members: 20
Latest: Cheeco
New This Month: 2
New This Week: 1
New Today: 0
Stats
Total Posts: 219
Total Topics: 80
Most Online Today: 3
Most Online Ever: 24
(January 05, 2020, 06:31:08 pm)
Users Online
Members: 1
Guests: 2
Total: 3

Author Topic: Employee System Example V4 Errors And Corrections  (Read 224 times)

Online Michael

  • Administrator
  • Sr. Member
  • *****
  • Posts: 251
  • Karma: +0/-0
  • Location: Margate, Kent, UK
  • Referrals: 0
Re: Employee System Example V4 Errors And Corrections
« on: September 07, 2019, 10:36:55 am »
I was going though my project management system updating the holiday planner to current version when I noticed the holiday report was showing all entries for all years as my project management system goes back a lot of years it was a lot.

so I made the following change to the query: qryHolidayListReport

I added a new field with the expression: HYear: Year([StartDate]) you can call it what you like

And A Criteria: Year([Forms]![frmHolidays]![txtDate])

For those new to access what this does is limits the output of the report to the current year being viewed on the holiday planner, I didn't think it needed a date range popup.

P.S. I used the start date only as I was only interested in holidays starting in a given year.

hope you find this of use mick
« Last Edit: November 17, 2019, 10:59:26 pm by Michael »

 

+-Recent Topics

User manual by Michael
January 22, 2020, 06:25:11 pm

UK Singles/Albums Charts 17 Jan 2020 To 23 Jan 2020 Analysis by Michael
January 18, 2020, 10:25:08 am

Project Status by Michael
January 17, 2020, 06:34:43 pm

First Chart (Test) by Michael
January 11, 2020, 09:27:19 pm

UK Singles/Albums Charts 10 Jan 2020 To 16 Jan 2020 Analysis by Michael
January 10, 2020, 07:35:57 pm

Concept of design by Michael
January 05, 2020, 01:08:18 pm

UK Singles/Albums Charts 03 Jan 2020 To 09 Jan 2020 Analysis by Michael
January 03, 2020, 11:56:45 pm

Members Deleted by Michael
January 02, 2020, 03:57:21 pm

Employee System Example V4 Errors And Corrections by Michael
December 29, 2019, 09:33:04 am

UK Singles/Albums Charts 27 Dec 2019 To 02 Jan 2020 Analysis by Michael
December 28, 2019, 07:58:25 am