Sorting data

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have this code on a form:
DoCmd.OpenForm "frm_chooser"
Forms!frm_chooser.Caption = "Add or Edit Training"
Forms!frm_chooser!lbl_add.Caption = "Add Training"
Forms!frm_chooser!lbl_edit.Caption = "Edit Training"
Forms!frm_chooser!cmb_edit_choice.ColumnCount = "3"
Forms!frm_chooser!cmb_edit_choice.ColumnWidths = "0.45"";1.80"";0.5"""
Forms!frm_chooser!cmb_edit_choice.RowSource = "SELECT dbo_sds_trn_class.
lifecycle_no, dbo_sds_trn_class.class_nm, dbo_sds_trn_class.available_dt
FROM dbo_sds_trn_class;"


I want to sort Ascending by dbo_sds_trn_class.available_dt first, then
dbo_sds_trn_class.lifecycle_no, then dbo_sds_trn_class.class_nm

I tried putting in ORDER BY dbo_sds_trn_class.available_dt, dbo_sds_trn_class.
lifecycle_no, dbo_sds_trn_class.class_nm;

I rcvd a compile error. I do not know anything about where code goes and the
format of it. Can someone resend me my code above and include the sorting
section as I have above?
 
I figured it out. Thank you.
I have this code on a form:
DoCmd.OpenForm "frm_chooser"
Forms!frm_chooser.Caption = "Add or Edit Training"
Forms!frm_chooser!lbl_add.Caption = "Add Training"
Forms!frm_chooser!lbl_edit.Caption = "Edit Training"
Forms!frm_chooser!cmb_edit_choice.ColumnCount = "3"
Forms!frm_chooser!cmb_edit_choice.ColumnWidths = "0.45"";1.80"";0.5"""
Forms!frm_chooser!cmb_edit_choice.RowSource = "SELECT dbo_sds_trn_class.
lifecycle_no, dbo_sds_trn_class.class_nm, dbo_sds_trn_class.available_dt
FROM dbo_sds_trn_class;"

I want to sort Ascending by dbo_sds_trn_class.available_dt first, then
dbo_sds_trn_class.lifecycle_no, then dbo_sds_trn_class.class_nm

I tried putting in ORDER BY dbo_sds_trn_class.available_dt, dbo_sds_trn_class.
lifecycle_no, dbo_sds_trn_class.class_nm;

I rcvd a compile error. I do not know anything about where code goes and the
format of it. Can someone resend me my code above and include the sorting
section as I have above?
Click to expand...
 
Back
Top