473,324 Members | 2,239 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,324 software developers and data experts.

Need a report to show gaps between last entry and next entry

12
I have 3 tables, employees, vehicles,Mileage.

I enter the mileage done, the start and end dates with a lookup value of one "vehicle" and one "employee", e.g employee id "003" "Jo Bloggs" drove "VK03 XXX" between "4/04/06" and "12/04/06".

next entry for same employee was "17 April" to "20th April".

I need to somehow distinguish that for any employee ID if there are any gaps. In the instance of "003" " jo Bloggs" there is no record covering dates 13/04/06 to 16/04/06 and possible many more depending on how many enteries?

Any help appreciated as I am really struggling with this one? :(
Aug 1 '06 #1
4 1487
comteck
179 100+
I responded to you before when you posted this, and I still don't quite understand what it is you are asking. You have 2 date ranges in your example:
4/04/06 to 12/04/06 and
17/04/06 to 20/04/06

It seems like you want to create a report for the gaps in between those 2 date ranges (13/04/06 to 16/04/06). I got you up to there. What I don't understand is what it is you want to report.

If you're entering the mileage with the start and end dates ( and I assume you're saving this data in a table), wouldn't this info be part of your ranges. In other words, let's say there was an entry for 14/04/06 to 15/04/06. Then the gap would not be between 13/04/06 and 16/04/06. Instead, there would be a gap between 12/04/06 and 14/04/06, and there would be another between 14/04/06 and 17/04/06. And there would still be nothing to report.

I don't know now if I'm making any sense. Anyway, I don't understand what you're trying to report.

comteck
Aug 1 '06 #2
AdrianE
12
Sorry, the basis for the report is to show if any logs are missing, each employee should have a record for every day of the miles driven.

Logged against employee 003 would be something like the following:

1st entry) 12th April to 17th April, registration is "xx1" miles driven "xx"
2nd entry) 21st April to 27th April, registration is "xx1" miles driven "xx"
3rd entry) 28th april to 31st April, registration is "xx1" miles driven "xx"

The aim of the report is to show for every employee which dates I need to chase for missing data. In this case it would be:

employee 003 no entry covering 18th April to 20th April.

Hope this explains it better? :o
Aug 2 '06 #3
AdrianE
12
I've also got 500 employees with 1 log sheet for each 2 week period..ish which is why I need a report to show which employees have a missing report and between which dates.

Cheers Adrian
Aug 2 '06 #4
comteck
179 100+
Is there anyone else that can offer assistance here? I still don't see what would be included in the report. It doesn't seem like there is any data to go into the report.

comteck
Aug 2 '06 #5

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

Similar topics

30
by: nephish | last post by:
Hey there, i have tried about every graphing package for python i can get to work on my system. gnuplot, pychart, biggles, gdchart, etc.. (cant get matplot to work) so far, they all are working...
2
by: Wayne Wengert | last post by:
This is my first attempt to re-write an old VB6 application that exported a CSV file to a .NET application that exports an XML file with the equivelent data. I have limited understanding of OO...
3
by: Robert McGregor | last post by:
Hi there, I was wondering if anyone could help with this problem. I have a table with about 250,000 rows that relate to files that have been processed elsewhere in our business. Each file has...
5
by: AdrianE | last post by:
I have a database where a record has a start date and an end date and is linked to an employee. Ho do I create a report that will show each employee and gaps between the employees next record...
7
by: fox | last post by:
Hi, Lacking javascript knowledge, I just realized why my project has a bug. I am using ASP to loop through a set of records while it creates URLs with a querystring that has a single value pair....
21
by: Johan Tibell | last post by:
I would be grateful if someone had a minute or two to review my hash table implementation. It's not yet commented but hopefully it's short and idiomatic enough to be readable. Some of the code...
1
by: AdrianE | last post by:
I have 3 tables 1st is Vehicles= reg make etc 2nd is employees= employee id, name surname etc 3rd is entry logs=registration, employee id and date (usually one each 2 weeks) How can I get a...
4
by: richierich | last post by:
First what I need help with is in a report that I have that I have hauled multiple truck loads with a particular truck on a particular day and I want on the report to show me on the footer of the...
4
by: sara | last post by:
Hi - I can't seem to choose the keywords to find an answer to this query - or maybe it's not in the posts. I have a database where the Buyers enter their Orders and then Accounts Payable posts...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.