473,226 Members | 1,719 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,226 software developers and data experts.

language to sort by a column in a subform

46
Suppose I have a form named Form1. On Form1 there is a subform named Subform1. Subform1 shows all transactions (and the date of the transactions) for the customer selected on Form1. I am trying to sort by the date of the transaction on Subform1. I have set the "order by" field to sort descending by date but it's acting funky (sometimes it is sorted correctly, sometimes opposite, sometimes mixed). I cannot figure out why this is. So, I figure a possible solution would be to have SQL language sort by the date in the Subform automatically when the form is opened. What would be the appropriate language? Thank you!
Oct 24 '07 #1
3 1397
ADezii
8,834 Expert 8TB
Suppose I have a form named Form1. On Form1 there is a subform named Subform1. Subform1 shows all transactions (and the date of the transactions) for the customer selected on Form1. I am trying to sort by the date of the transaction on Subform1. I have set the "order by" field to sort descending by date but it's acting funky (sometimes it is sorted correctly, sometimes opposite, sometimes mixed). I cannot figure out why this is. So, I figure a possible solution would be to have SQL language sort by the date in the Subform automatically when the form is opened. What would be the appropriate language? Thank you!
Before you do anything else, is the Transaction Date Field in the Sub-Form bound to a Field that is of the Date/Time type?
Oct 24 '07 #2
bbatson
46
It is not bound to anything. In this hypothetical, the form and subform would be linked by a customer ID.
Oct 24 '07 #3
ADezii
8,834 Expert 8TB
It is not bound to anything. In this hypothetical, the form and subform would be linked by a customer ID.
Set the RecordSource of the Sub-Form to a Query or a SQL Statement with an ORDER BY [Transaction Date] Clause.
Oct 25 '07 #4

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

Similar topics

1
by: John | last post by:
(acc2002) I have a (continuous) subform (not datasheet) designed to look like columns of data. On each column "header" is a command button that when pressed, sort the records via that field. ...
3
by: A Clark | last post by:
I have a subform that displays a datasheet. There are a couple of different queries that can be displayed in the datasheet. The queries are available in a combo box on the main form. The problem...
1
by: angel duran | last post by:
Hi... i'm trying to accomplish this and i will be using some pictures so you can easily follow me along. I have this form <link>http://img30.exs.cx/my.php?loc=img30&image=4214.jpg</link> and in...
12
by: MLH | last post by:
I have created two forms: frmBrowseNegsMainform and frmBrowseNegsSubform. I put a subform control on the first of these. The SourceObject property for the subform control is, of course,...
2
by: Tim Marshall | last post by:
The following is happening in two instances in A2003. The one I s\describe is the easiest one. Theme controls and autocorrupt have been turned off long ago. An unbound main form with a list...
1
by: christianlott1 | last post by:
I want to provide users with an interface to create a custom merge (all in Access, not Word). User will put in a set of brackets ("<>") in a memo field and when they click the merge button it will...
2
by: ncsthbell | last post by:
I have a form with a subform and I am trying to change the size of a column on the subform. I am following the instructions in the access help 'Change the layout of a subform in Datasheet view" to...
3
by: RamiH | last post by:
Hi, I am using a listbox to show data from a certain table, i want the user, after the listbox is filled, to be able to sort the data according to the column of his choice. I could sort the table...
2
by: Element | last post by:
I have a master form with a simple subform that displays line items in datasheet mode. Everything works fine, except that when the subform has the focus, the standard Access sorting and filtering...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.