The default settings for this page will show all accounts between todays' date for the next month. Use the calendar to select different dates as required.
Results for Start Date=30/12/1899, End date=
SQL = SELECT * FROM Jobs,AccountDetails,Drivers WHERE pickupdate >= #16/08/2012# AND pickupdate <= #23/09/2012# and Jobs.accountID = AccountDetails.AccountID AND Jobs.DriverID=Drivers.DriverID AND farename LIKE '%' AND destination LIKE '%' AND Jobs.DriverID Like '%' AND Accountname like '%' AND (Plate LIKE '%%%' OR Plate IS NULL) AND address LIKE '%%%' ORDER BY pickupdate,pickuptime
| Status | Status |
Time |
Pickup |
Name/Pax |
Destination |
Not A/C Fare |
Account Fare | Payment Type | Account |
Driver
|
Plate |
Pre |
||
| Jobs=0 | Totals |
£ | £ | £0 | ||||||||||
INSERT NEW JOB BELOW
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\db\848cars.mdb