Results 1 to 2 of 2
Thread: Order By in Design View
2015-10-18, 14:21 #1
- Join Date
- Oct 2015
- Thanked 0 Times in 0 Posts
Order By in Design View
I have a database that I need to sort when the database opens.
I need it to sort by the department field and then alphabetized within that field. I know how to have it sort by the department field, but can't figure out the rest.
Anyone have any ideas?
2015-10-18, 18:39 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 33 Times in 33 Posts
Well, considering there is no "department field", you are going to have a problem.
Assuming there will be one, first remove any sorting. Then, select each column for sorting in the reverse order you want; that is, if you wanted to sort by "Department" and then by "Item", you'd first sort the "Item" column and then the "Department" column.
Beyond that, you don't have a database here; you don't have much more than a spreadsheet. There is a litany of glaring problems immediately visible: your Food table doesn't have a Primary Key; you defined your Quanity (I assume this was supposed to be Quantity) as a text field which eliminates doing anything like using this for totals and such; nothing is indexed; you shouldn't be entering data directly into a table, you should be using forms for data entry; etc.
I'm assuming this is your first foray with a relational database. This is not something you can easily pick-up on your own. I'd strongly suggest you take a class to get you started-off on the right foot. Quite frankly, you aren't likely to get much help from anyone in this or any other forum, because although many of us are here to help people with their questions, we don't have the time to teach Access to anyone.