Okay - so you can probably guess by my subject line that I'm a newbie. Well, not really a newbie but someone who creates in Access only once in a blue moon so I forget a lot of how it works.
I have a database where I record my projects. Projects are prioritized by both ship date and priority. In other words, a project can have a priority 1 but the ship date may be 6 months old, or a project can have a priority 1 with a ship date of tomorrow. I know how to query on this information. No problem.
What I'd like to do is have my query report the order by number. I'm calling it Job Order. In other words, the order in which I need to do these projects. I may have several Priority 1s but because they have different ship dates, I need to know what to work on first.
Basically, what I'd like it to magically do is autonumber the results from the query. That autonumber would tell me what to work on first. I don't know if Queries do autonumbering though! I tried to use Count but that just counts the record so I simply get the number 1 for each record.
Once the query runs, it would look like this:
Model 100
Priority 1
Ship Date 2/1/09
Job Order 1
Model 200
Priority 1
Ship Date 2/4/09
Job Order 2
Model 300
Priority 2
Ship Date 1/1/09
Job Order 3
and so on...
Any help you can offer would be greatly appreciated!
Anne