Creating form for data entry

[salisbut]

I currently have a database where the majority of the information is taken from imported data from an excel spreadsheet. The remainder of it is hardcoded in. I have a table which does this called tblHardcode. In each month there are 34 different records which must be manually entered. Currently the database user inputs these in the tblHardcode. What I would like to do is create a form which only shows the specific month that they would like to edit instead of showing the entirety of the table. I also would like to customize the order of the entries instead of them being specifically alphabetical. Where do I start and how do I deal with reorganizing fields. I have attached database. The only questions I have are about tblHardcode.

[jgelpi16]

You can handle the sort a couple of ways. You can either set up a field in your tblHardcode called "Sort" and set it to an Autonumber. You can also open the Record Source of your form and set the "Sort" attribute to Ascending/Descending of the field you want to sort by. If you have a date field in your tblHardcode you can set the Criteria of your Record Source to "BETWEEN DateSerial(Year(Date()), Month(Date()), 1) and DateSerial(Year(Date()), Month(Date()), 0)" (minus the "s). This will show everything for last month. OR you can do "BETWEEN DateSerial(Year(Date()), Month(Date()), 1) and Date()" to show between the beginning of last month and today.

[salisbut]

Ok thanks I am making good progress! Form is currently up and running with five fields: Company, Month, Year, $Amount, MW. The date sort worked like a charm and now it has the specific data for a month. Now the data for the month is sorted alphabetically by the company. How do I apply a custom sort to companies? For example I would like some to be grouped together that are not near each other in the alphabet because they strongly correlate to each other for data entry.

[salisbut]

It is impossible to do nested iff's because there are 31 records which would be past limitations

[jgelpi16]

If the companies are related, but not alphabetically I think you would need to add the sort column to your table. I would recommend creating a "company" table and adding the company name and a "sort" field. Link that table into your form record source and sort on the company sort. This should pull your like companies together.

[salisbut]

Solved! Thanks for the quick responses!