473,385 Members | 2,015 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Date Count

67
Hi guys

I am trying to create a form that shows the number of days an employee has had off.

I type in the users name and from that i get a subform with the history of absences and i also want a text box that counts the amount of days between FromDate and ToDate from the users history.

Please help

Regards
Wayne
Jan 28 '09 #1
6 1551
NeoPa
32,556 Expert Mod 16PB
You haven't given us much information to work with here Wayne. Nor what format the information you have mentioned is in.

From this it's not really possible even to consider your problem properly.

Try some more precise details and we'll see what we can do.
Jan 28 '09 #2
Wayneyh
67
Sorry for the lack of info. Basically i am trying to count the days absent an employeehas had off from a Table, tblAbsent. The table contains the following fields:-

EmployeesName - Textbox
FromDate - ShortDate
ToDate - ShortDate
AbsentReason - Memo
OfficeNotes - Memo

I created a Form, frmAbsent with all the above. The employee could have several entries into the table. I want to search for an employee and see the history of absences in a subform on frmAbsent and either a textbox or another subform showing the amount of days off by counting all the fromDates and ToDates for that employee.

I tried a query but it didn't work.
Jan 28 '09 #3
Wayneyh
67
Sorry to complicate things. All I am trying to do is count the days between the FromDate And ToDate.

Regards

Wayne
Jan 28 '09 #4
NeoPa
32,556 Expert Mod 16PB
Is it simply the DateDiff() function you're looking for then?
Jan 28 '09 #5
Wayneyh
67
Thanks Neopa, Thats exactly it. Had a serious brain block today. Thanks again.

Regards
Jan 28 '09 #6
NeoPa
32,556 Expert Mod 16PB
Excellent :)

We all go there. trust me ;)
Jan 29 '09 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: David B | last post by:
I have 2 querys with the following in the date criteria Between DateAdd("m",-6,(!!)) And (!!) Between DateAdd("m",-24,(!!)) And DateAdd("m",-6,(!!)) Problem is they both look at the same...
2
by: BlackFireNova | last post by:
I have an Access 2003 mdb which contains software records. I need to sort on a particular type of software, and then identify and count how many copies there are per each group of that type...
5
by: Alicia | last post by:
Yes, but will that skip a week and group by the date for me? I basically wanted something that would do a count of the dates, then group them by their week name.. BEFORE: Resource Date ...
2
by: Keith | last post by:
Good Afternoon, New to .Net. I am trying to pass date/time values to a MS Access query depending on what value is selected from a dropdown list box (January, February, etc). I have declared...
1
by: Wayne | last post by:
Hi all I'm trying to calculate the number of days (or workdays) between 2 given dates that do not include weekend days or public holidays (public holidays are user defined from a dbase, have a...
1
by: Me | last post by:
I need to get the past 5(x) months for certaing calculations. What I have is listed below: ######################################## my $year, $month_str, $month_int; foreach my $count...
1
by: Budd | last post by:
Hi everyone i got a problem on date, it is... 1, i get the date from calendar component 2, compare today and selected date is equal (compare method) 3 count the number of day between this...
7
by: No bother | last post by:
I have a table which has, among other fields, a date field. I want to get a count of records where certain criteria are met for, say, three days in a row. For example: NumWidgets Date...
4
by: Simon Gare | last post by:
Hi all, I am trying to retrieve a count of booking entries made 30 days ago, below is the end of the query I am having problems with. dbo.booking_form.TimeOfBooking = DATEADD(day, -30,...
3
by: plaguna | last post by:
I'm trying to Count data in a Query Combining two different fields based on the "Date" the product was sold, and for some reason I get a wrong data. When I use only this expression, It works fine:...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.