Hi,
I'm creating a new databse and have a couple of problems I'd greatly
appreciate any feedback on.
1) I have an order form and would like to set it, so that when the form
is opened, the focus is set to my reference field and the find command
is executed prompting the user for the reference he/she wants to find.
I pasted the code from a Find command box i created, but cant work out
how to use the setfocus when the form is opened to go straight to that
field. The plan was to put this code into the onopen property.
2) Every order has an order type - there are about 5 types. When
creating a report I would like Access to count the number of each order
type within a certain time period. I've managed to create a query which
prompts me for the time period, but cannot get Access to count each
order type.
In case this is a bit unclear....:
If i have ten orders, 3 are of type A, 4 of type B and 3 of type C, I
would like a report to show
Type A - 3 Orders
Type B - 4 Orders
Type C - 3 Orders .........just simply counting the number of different
order types.
Can anyone help?
Thanks