Sorting in Microsoft Access?

Question

I'm trying to change the field that Microsoft Access uses to sort things in a form, but I can't figure it out. Please help

Answer 1

View the form you're having trouble with.

Go into Design View.

Click Edit, Select Form.

Click View, Properties.

On the Data tab, enter a fieldname in the Order By box



If this box is left BLANK, the sort used in the underlying query or table is used by the form instead.

Answer 2

upload a field. Use it for a serial date, yyyys (the place s is the season style - 0 = automn, one million = spring, 2 = summer season, 3 = wintry climate). style with the aid of that field, and you gets the main important style with the aid of twelve months, then with the aid of season. you do no longer ought to decide on the sector or tutor it. 4 straight forward replace statements might fill the sector the 1st time (the place date between for each season - careful of the reality that a date without time distinctive is the commencing up of that day, hour of darkness), then fill it during your insert ordinary.

Answer 3

generally you'd need to create a query and put the sort in the query, then build a subform based on the query.