month
- Thread starter superrob5
- Start date
Mile-O
Back once again...
- Local time
- Today, 22:17
- Joined
- Dec 10, 2002
- Messages
- 11,316
...and you've only stored the month abbreviations as text in your tables?
If you have a date that relates to these then you could simply sort it by ascending values and change the field's format to be Format([MyField], "mmm") and nobody would be any the wiser.
If you have a date that relates to these then you could simply sort it by ascending values and change the field's format to be Format([MyField], "mmm") and nobody would be any the wiser.
right now I have a table that will store this info.
employee Table
EmpID
EmpFName
EmpLName
other info
Then I have a Hours Table
EmpID this is linked to the employee tabel and first three fields
Year the primary key
Month
Hours
then I have a month table that is a look up to the hours table
Monthid
Month
1 Jan
2 Feb etc....
I have a form that has EmpID, Firstname, lastname. Then a subform
Year, Month, Hours
month is a combo box
I want to be able to when scrolling through different employees to sort by year then by month.
Rob
employee Table
EmpID
EmpFName
EmpLName
other info
Then I have a Hours Table
EmpID this is linked to the employee tabel and first three fields
Year the primary key
Month
Hours
then I have a month table that is a look up to the hours table
Monthid
Month
1 Jan
2 Feb etc....
I have a form that has EmpID, Firstname, lastname. Then a subform
Year, Month, Hours
month is a combo box
I want to be able to when scrolling through different employees to sort by year then by month.
Rob
Last edited:
Tiro Cupidus
Registered User.
- Local time
- Today, 16:17
- Joined
- Apr 25, 2002
- Messages
- 263
In the query, include the ID field from the Month table and sort by it.
employee Table
EmpID
EmpFName
EmpLName
other info
Hours Table
EmpID this is linked to the employee tabel and first three fields
Year the primary key
Month
Hours
month is a combo box pointed to the table months
which has
monthid
month
On the combo box it doesnt use the primary key it points to the actual month. So when it stores the information it stores the month. Check it out.
EmpID
EmpFName
EmpLName
other info
Hours Table
EmpID this is linked to the employee tabel and first three fields
Year the primary key
Month
Hours
month is a combo box pointed to the table months
which has
monthid
month
On the combo box it doesnt use the primary key it points to the actual month. So when it stores the information it stores the month. Check it out.
Tiro Cupidus
Registered User.
- Local time
- Today, 16:17
- Joined
- Apr 25, 2002
- Messages
- 263
I see what you wanted to do now. I'm not sure how to do it exactly the way you want, but I did apply a solution.
- The form is based on qryHours now instead of the table.
- I set up a relationship between the Month and Hours tables (there were one or two other relationships that need to be set up, but I didn't do it).
- I changed the Month field in the Hours table to MonthID.
- In qryHours I've combined the MonthID and Month fields to give the months in the combo box a sort of ID so the sorting will be correct.
Now this probably wasn't the best way to do it, or the way you wanted it, but I figured I'd give it a try.
- The form is based on qryHours now instead of the table.
- I set up a relationship between the Month and Hours tables (there were one or two other relationships that need to be set up, but I didn't do it).
- I changed the Month field in the Hours table to MonthID.
- In qryHours I've combined the MonthID and Month fields to give the months in the combo box a sort of ID so the sorting will be correct.
Now this probably wasn't the best way to do it, or the way you wanted it, but I figured I'd give it a try.
