Search results

Am a bit puzzled, as I had expected the result of the query as below : COMPANYCODE DATEPAYABLE COMPANYNAME Amount 4 2/8/2013 Company 4 100 4 12/19/2012 Company 4 500 3 1/2/2013 Company 3 400 3 11/27/2012 Company 3 700 2 2/1/2013 Company 2 200 2 12/7/2012 Company 2 600 1 1/16/2012 Company 1 300...

what happens when you do ? SELECT [Adhoc-BL].COMPANYCODE, [Adhoc-BL].DATEPAYABLE, [Adhoc-BL].COMPANYNAME, [Adhoc-BL].Amount FROM [Adhoc-BL] ORDER BY [Adhoc-BL].COMPANYCODE DESC , [Adhoc-BL].DATEPAYABLE DESC; Thanks

Above is a query, which you can design in the query builder design grid. "Table1" is your table and Field1 is the field in your table which contains the data. The field "TheLength" gets the length of the data in Field1 and the where clause filters out data that do not have a length of 19. In...

Have you tried something like below : SELECT Table1.Field1, Len([Field1]) AS TheLength FROM Table1 WHERE (((Len([Field1]))<>19)); Thanks

At first glance, there appears to be a bug in my last sentence in the previous post. Try fiddling with it the way we fiddle with the End Date. something more to look at meanwhile : SELECT myTable.VesselID, myTable.startDateVesselOutsideUKwaters, myTable.endDateVesselOutsideUKwaters...

Till some one comes along, just a bit of off the cuff thinking : have a column which checks if Month and Year of "end date outside uk waters" is later than Month December and Year 2012, if Yes EndDateForCalculation = 31st December 2012 else EndDateForCalculation = end date outside uk waters...

Till jdraw's back, just check out, if below is what you are looking for : http://www.access-programmers.co.uk/forums/showthread.php?t=184940 Thanks

Hi John, I still can't rep lagbolt. Still get the message - "You need to spread some ....." It's now more than 30 days, since 3rd Nov. Is there some way, you could check this out ? The odd part is, I am able to rep others. Sorry for the trouble. Thanks

You don't have to talk to anyone for this. At your end, convert the EventDate to MM/DD/YYYY format & use the converted Date field in our queries. Just google, how to convert DD/MM/YYYY to MM/DD/YYYY in excel or access. You can also change the Type of EventDate & EventTime fields in your access...

1) IMHO, Unless we have the dates & times in MM/DD/YYYY format, it will be difficult to proceed. It can be done in access as well as the source Excel before importing. Would prefer it to be done before importing, as I believe it will be easier. 2) The EventDate & EventTime fields should be in...

Now I am confused. Is it to be read as 2nd of May 2012 or 5th of Feb 2012. If your data in source table is in MM/DD/YYYY format, then there is no problem. Import it as it is. Just see that EvenDate & EventTime are Date/Time field. We want the Dates in our Access Table to be in MM/DD/YYYY...

It's just to check if the Number Of Days being shown by the query is correct & we have not committed any mistake. Go to Design Mode for the query qryCart & remove the 0 or 1 criteria, which is there under the ValidData field. The query will now return the Number of Days between the IN Date &...

Before changing the qrycart to below, remove the 0 or 1 criteria in query design mode & see if the results of Number of days is correct. Try adding the below to qryCart in the SELECT clause IIf([TheOutDateTime]<[TheInDateTime],"Not Valid","Valid") AS Valid_Data_1 qryCart SELECT...

Try out the 1st solution. Make a copy of your table & name it as tblEvents. If the field names are same as what you have shown in your 1st post. Then simply copy the queries as I have given & save them under the same names. Then run the final query & see what happens. This will depend on you...

1) Check out if below gives some ideas (qryCart is the final query supposed to give the results) Note : 99%, there is a chance of some bug. qryDistinctDatesStaff SELECT DISTINCT tblEvents.EventDate, tblEvents.StaffName FROM tblEvents; qryIn Have taken the Minimum as criteria...

Till some one comes along, just check out if below gives some guidelines : http://www.accessforums.net/queries/query-2-objects-25885.html Thanks

Till some one comes along, a few thoughts : tblEmployees EmployeeID - PK ....... tblDepartments DepartmentID - PK DepartmentName .... tblEmployeeDepartments EmployeeDepartmentID - PK EmployeeID - FK DepartmentID - FK DateOfJoiningDepartment tblTrainingCourses TrainingCourseID - PK...

Glad you found it helpful. Do not know if this forum is oriented towards php & mysql ( I may be wrong ). Nearly a year back, when I was dabbling with php & mysql, I found the guys / gals at http://forums.devshed.com/ very helpful, specially for php & mysql. Though, I have not used this (...

Till some one comes along, have you tried something like below ( the logic ): <body> <form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>"> <table width="599" border="1"> <tr> <th>Keyword <input name="txtKeyword" type="text" id="txtKeyword"...