P patriot76 Registered User. Local time Today, 12:48 Joined Jan 11, 2005 Messages 24 Mar 14, 2005 #1 I have a table with date/time format column that I import for Excel. There can be numerous date/time stamps for each day. The question is how can I count the total number of different days that a person has worked or done a certain task?
I have a table with date/time format column that I import for Excel. There can be numerous date/time stamps for each day. The question is how can I count the total number of different days that a person has worked or done a certain task?
U Ukraine82 Registered User. Local time Today, 10:48 Joined Jun 14, 2004 Messages 346 Mar 14, 2005 #2 I suggest you make a crosstab query that will break the person name along with date count for that individual person. hth, Michael
I suggest you make a crosstab query that will break the person name along with date count for that individual person. hth, Michael
P patriot76 Registered User. Local time Today, 12:48 Joined Jan 11, 2005 Messages 24 Mar 14, 2005 #3 date Not sure what you mean.
U Ukraine82 Registered User. Local time Today, 10:48 Joined Jun 14, 2004 Messages 346 Mar 14, 2005 #4 Take a look at the attachment file. Let me know if that what you're looking for. hth, Michael Attachments Sample.zip Sample.zip 18.1 KB · Views: 136
P patriot76 Registered User. Local time Today, 12:48 Joined Jan 11, 2005 Messages 24 Mar 15, 2005 #5 aTTACHED FILE Can't unzip the file for some reason?
