Sorting By The Most Current Date.
Hey all,
I have what is probably a simple question.
I want to sort my date field in a query by the most recent date.
When I use ascending or descending it looks at the Month/day/year to sort it.
I need it to look at year/day/month.
Any help would be awesome.
View Complete Forum Thread with Replies
Related Forum Messages:
How Do I Compair Table Date To Current Date
Hello, I was wondering how to check a date in a table vs current date and then put a yes/no in a colum if the date in the table is past current date. In the form I know it should be wrote in the Upon Open Event But I am unsure of the code. Thank you for your time, Derek L
View Replies !
Sorting By Date
I have the data below in a query in Access, and I want it to sort by the Week Begin date. I have put a sort on for 'Ascending' but it doesn't work. (Due to the 29th being after the 28th - regardless of month) Is there any way I can force the sort in this query ? It must be in the same query though, as I could probably do it by using this query in another one then sorting that. However, I don't want to do that for reasons I won't bore you with. WeekBegin Count 05/09/05 137 12/09/05 90 19/09/05 22 26/09/05 55 29/08/05 122 PS - I should mention that I think it is because the WekBegin date is an expression based on an actual date field. Therefore I believe it's treating it as some sort of text field. Any help would be appreciated. Thanks. J.
View Replies !
Sorting By Date
Hi, I've just started playing with Access 2002 (Office XP) and I@m having a little bit of trouble. I'm using the Query Wizard to summarise my database giving me average values for each month. When the query is first run it displays in the correct month order: April, May, June, July, August, September. But viewing the query again or when trying to graph the data in a Form, the sorting forces alphabetical order: April, August, July, June, May, September. How can I get the query/form to return the results in true month order? Here's the SQL info which the Wizard created: SELECT DISTINCTROW Format$([Raw Data].[TimeStamp],'mmmm yyyy') AS [TimeStamp By Month], Avg([Raw Data].[Indoor Temperature]) AS [Avg Of Indoor Temperature], Min([Raw Data].[Indoor Temperature]) AS [Min Of Indoor Temperature], Max([Raw Data].[Indoor Temperature]) AS [Max Of Indoor Temperature] FROM [Raw Data] GROUP BY Format$([Raw Data].[TimeStamp],'mmmm yyyy'), Year([Raw Data].[TimeStamp])*12+DatePart('m',[Raw Data].[TimeStamp])-1; Thanks in advance for your help. David
View Replies !
Sorting By Date
I have a subform that simulates a listbox and I click on the header label to activate the sort. My problem is sorting by date. Below is the sort function and one of the date labels that I need to sort on. Sort Function:Code: ========================================== Private Function SortOrder(col As String, xorder As String) As Integer Dim strSQL As String Dim sf As Form Set sf = Forms!frmMainEntry!fctlNotifications.Form strSQL = "SELECT DISTINCTROW ProgramID, ProgramDescription, Facility, ResponsibleParty, DueDate, FrequencyOfService, AdvancedNoticeDate " strSQL = strSQL & "FROM qryProgramList " strSQL = strSQL & "ORDER BY " & col & " " & xorder sf.RecordSource = strSQL sf.Form.Requery End Function ========================================== On-Click Date:Code: ========================================== Private Sub lblDueDate_Click() Dim response As Integer If Me.txtSortOrder = "DESC" Then response = SortOrder(CDate(DueDate), "asc") Me.txtSortOrder = "asc" Else response = SortOrder(CDate(DueDate), "DESC") Me.txtSortOrder = "DESC" End If End Sub ========================================== I'm not sure if I should convert the date into something that can be sorted or just leave it as a date. I can't get it to work. Help please. Thanks, PC
View Replies !
Sorting By Date
help w/sorting two columns one with date checked out, other with date due back. some are overdue and there is not a date entered yet. need to sort by the longest overdue first and leave out those that have already been returned
View Replies !
Sorting By Date And Time
Hello, I am having some trouble sorting my date and times. I have them both working great individually with RunCommand Sort Ascending after Update. The problem is, the dates will get jumbled up after the time is sorted. Is there a way to connect the two fields where the dates will always stay in order? I have attached a pic of this DB if it helps any. Thanks so much for any help. Fritz
View Replies !
Sorting A Date Field
i have a date field where about 80% of the data is entered in the format dd/mm/yyyy but the rest may be year only since the exact date is not known. Therefore, it does not have an input mask or a format set. Is it still possible to sort on that field? (As i write this i realise it is probably a dumb question but always worth a shot!)
View Replies !
Sorting Query By Date & Employee Name
I created a query which at first was simply to run a query which asks you for a drivers name, however we have decided that now we want to sort by the employee name as well as by a specified date range. I originaly had it set up to select the driver name with this in the criteria field in the Driver Name column: [Enter Driver Name] Then I tried to enter the following in to the criteria field in the date column: Between [Enter Start Date: (Format MM-DD-YY)] And [Enter End Date: (Format MM-DD-YY] However when I run the query it asks me for the date about 4 times, and then it goes to a blank report. I am sure I am not doing this properly somehow, anyone care to help out?
View Replies !
XTab Colun Heading Date Sorting
I have a cross tab query for which I want to display the dayes in mmm-yy format. I am grappling with the problem that this is essentially a string, so gets sorted alphanumerically. Having read around related forums I have tried basing the XTab on a select query, which is sorted by the conventialal date, but also has another field that gives a date using Format([DateAdded],"mmm-yy"). Trouble is, Access only lets me bring across 1 column heading, so I must sort on the column I display, and this doesn't solve the problem. The coulmn headings are not be fixed (i.e. "Jan";"Feb" etc) as the months are financial year months (April - March). I can get this too work by using yyyy/mm, but my board of directors are not happy with this format. Any ideas. I would be open to re-querying my Xtab from another query of from a report if that worked. Cheers Mike
View Replies !
Current Date +1
I want the query to return the results of all records that are for the next day. Sort of like =Date() +1 Please help
View Replies !
Current Date
There is a Date Submitted in my form that I would like it automatically poplulated with the current date. How do I do that?
View Replies !
Current N System Date
dear all what is the difference between current date and system date? for current date : =now() for system date : =date() am i right as above? many many thx
View Replies !
Current Date Querys
Hello, I have about 1500 records in a table. We use a form to search through the records to find info on certain accounts. We now want to only search through accounts that are current, so I made a query to see only current accounts. I switched the search form from going off data right from the table to the new current date query. Now when you load the form it says "running query" and the application stops responding. The query seems to load up quick in raw format.. how come the application freezes when searching using the query instead?? thanks, Matt
View Replies !
Most Current Date Query
Hi there, I am trying to put a query on my form which selects the most recent date of a members attendance from an attendance table and displays it in a text box, the code I am using is: Private Sub Text41_BeforeUpdate(Cancel As Integer) SELECT MAX(Attendance.AttendDate) as "LastAttended" FROM Attendance WHERE Attendance.membershipNo = Forms!Customer.sbfAttendance.Form.membershipNo End Sub Customer is my main form and Attendance is my subform. I think the mistake is that I dont have a field called last attended (you are not supposed to store data like this are you) and I need it to display in my text box (text41) on the main form Thanks in advance, Jon
View Replies !
Printing Current Date
When I print queries (and maybe forms) I would like to have the date printed on the sheet so I know when I printed it out. How should I do this?? Thanks
View Replies !
30 Days From Current Date
Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.
View Replies !
Current Date In SQL Query
Maybe a simple question, but i do not know how to put the current date in the WHERE clause of a SQL query. The query i have so far: select [table1].*, [table2].* from [table1], [table2] where [table1].[field] = [table2].[field] and [table1].[enddate] is null After this there has to be something like and [table1].[begindate] < [Date] (where [date] is the expression) I know that with Date() or Now() the expression can be made, but i do not know how, please advise.. Thanks in advance
View Replies !
Date - Current Month
Hi, I hoping someone can assist me here, I've looked through the forum for other date related threads raised, but none seem to assist me with what I need to achieve. I have created a query with an appropriate date field, and I am can't seem to work out how to write the correct formulae to get the query to only show data with a date range for the current month only. I don't want the user to be prompted to enter any information, I want the query to automatically always, when in the current month only show data for the current month. Any assistance would be most appreciated. John
View Replies !
Insert Current Date!?!?!
Help! Im trying to get a text box on a form to always automatically insert the current date. This seems like it would be so easy to me but apparently im stooopid. Thanks to anyone that can help. ( I already have the field in the table, and its in the query)
View Replies !
Insert Current Date!?!?!
Help! Im trying to get a text box on a form to always automatically insert the current date. This seems like it would be so easy to me but apparently im stooopid. Thanks to anyone that can help. ( I already have the field in the table, and its in the query)
View Replies !
Use Current Date To Change A Value In Records
I have a db that is a checkbook register. I use a field in each transaction record to tell whether the transaction is current or is a future transaction (if it is in the future then it doesn't yet affect my balance). For instance, if the item is not scheduled to be paid for two weeks (I schedule payments with online banking), I check the "future item" box, then that record for that item isn't included in the report that tells me my current balance. How can I automatically take away that check mark on records when the date in that record becomes todays date (or before today)? Because at that point it is no longer a "future" transaction but is current. I could do this manually but it seems like there should be a way to do it automatically.
View Replies !
Current Month / Date Problem
I have the following code that should populate the current month date range in the startdate and endDate fields of a form. I do the same thing for the current year and that works great. Can someone tell me what is wrong with the code for the month button. It displays 1/9/07 - 2/8/07. If the current month is September, it should give date ranges from 9/01/07 - 9/30/07. Private Sub cmdmonth_Click() 'Sets the Date From and Date To text boxes 'to show complete month (from start to end of current month) Me!StartDate = CDate("01/" & Month(Date) & "/" & YEAR(Date)) Me!EndDate = DateAdd("d", -1, DateAdd("mm", 1, Me!StartDate)) End Sub The code below works great for the year. It displays 1/1/2007 - 12/31/07 Private Sub cmdyear_Click() 'Sets the Date From and Date To text boxes 'to show complete current year Me!StartDate = CDate("01/01/" & YEAR(Date)) Me!EndDate = DateAdd("d", -1, DateAdd("yyyy", 1, Me!StartDate)) End Sub
View Replies !
Need A Query To Produce Current Date
Guys, I am trying to put together a query that will give me a calculation of days between the currect date and a date in the future. How do I tell a query that I want to display the current date, and then calculate this?
View Replies !
How To Check If Current Date Is Between Two Dates
Hi, I have an arrival date and a departure date and I need to work out if the current date is within the two dates. It's a criteria for one of my fields on the query I'm using as the backbone for a list box. Any help greatly appreciated :D Thanks, Adzi
View Replies !
Updating A Field To Current Date
I have a form named 'Race'. It uses table 'Tasks'. I want to click a command button and have the 'Completed Date' field updated to the current date. Can anyone tell me how to code the command button? Thanks! Sunny
View Replies !
Current Date/Time Field
I have a form with date/time field. I have the default value at =Now(). My problem is I would like for this particular field to stay with the current date/time all the time. I mean if I created a form last week with the date/time of 3/14/2005 12:54:34 PM and go back to the same form to edit something this week I would like for that particular date/time to be the current date/time and not the date/time from the week and time the original form was created. Thanks for any help!
View Replies !
Only Allow Date Entry For Current Month
Hello, I am a little familiar with Access but having a problem figuring out how to alert a user that the date entered on a form is not the current month. I was hoping to have a warning msgbox pop up alerting the user. I am trying to prevent incorrect date entry. Thank you very much
View Replies !
|
TRACKER
