Go Back   Access World Forums > Search Forums

 
Showing results 1 to 3 of 3
Search took 0.02 seconds.
Search: Posts Made By: arnelgp
Forum: Queries 08-21-2019, 11:32 PM
Replies: 6
Views: 129
Posted By arnelgp
Re: How to omit expired data from report

without the filter, >= Date, do you see any record that might be included based on RenewalDate?
Forum: Queries 08-21-2019, 09:39 PM
Replies: 6
Views: 129
Posted By arnelgp
Re: How to omit expired data from report

date is a reserved word for a built-in function.
change RenewalDate: DateAdd("yyyy", 1 [Attendance].[Date]).
filter on this calculated field:

>= Date
Forum: Queries 08-21-2019, 09:19 PM
Replies: 6
Views: 129
Posted By arnelgp
Re: How to omit expired data from report

Points are cumulative from the first day of his work when he is late/early quit/absent?
you can sum all points that are in present year:

ThisYearPoint: (Select Sum(T1.Point) From Attenance As T1 ...
Showing results 1 to 3 of 3

 
Forum Jump



All times are GMT -8. The time now is 04:46 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World