Search form with Two parameters

[karanvemuri]

i ned to create a search form with two parameters agent name and Date. The search criteria will be given on the two text boxes in the search from one for date and one for agent, and the results should be displayed in a list box below... any ideas are greatly appreciated.

[alansidman]

Watch this

http://www.datapigtechnologies.com/f...earchform.html

Alan

[karanvemuri]

thts exactly wat i was lookin for, thanks Alan, had another query though

I need to create a report based on a query where report shows the Agent name, total no of orders that he worked on today, with total no of orders the agent closed today itself i.e as per field 'closed' any ideas where to start.

[alansidman]

Create an aggregate query using the fields for Agent, Orders Worked and Orders Closed. Group on the Agent and sum on the other two fields. To make a query aggregate, click on the Greek Sigma

Alan

[karanvemuri]

HI Alan, i have no fields for orders closed and orders worked. I have a form where agent enters the order number everyday and he leaves the status field as Open or Closed. so basicaly i ned a report where it shows the agent name, total no of orders worked by the agent for today which will be including both Open and closed status. and also the total no of orders which are in "closed "state for today

[alansidman]

Ok. A couple of ways to solve this. In your query, change to an aggregatge and sum on the Status field grouping on the person and date. This will give you the total orders by date by person.

In a new query, do the same as above but in the criteria for status, put "closed." This will give you the number of orders closed by person by date.


Alan

[karanvemuri]

Ok. A couple of ways to solve this. In your query, change to an aggregatge and sum on the Status field grouping on the person and date. This will give you the total orders by date by person.

Alan not able to get the quote highlighted in red, can you elaborate a little? thanks again

[alansidman]

With your query open in design view, click on the Greek Sigma (Looks like a Captial E). In the status field, change the term group on to Sum. Run your query with only three fields, Status, Person and Date.

Alan

[karanvemuri]

Can i create a report where i will be able to show both the Query results Alan?

[alansidman]

I'm thinking that you can. Have you tried making one report from the query and then creating a subreport from the second query. I don't do much with reports. You may want to start a new thread (as it is a slightly different subject)and post it so that you get as many eyes as possible on it. I may not be your best resource for reports as I don't use them often.

http://www.databasedev.co.uk/access2007_subreports.html

Alan

[karanvemuri]

HI Alan,thanks for the link, having a problem with the querys now though. Whenever i run the querys...m having an error stating Datatype mismatch in criteria Expression.???

[alansidman]

This means that where you are trying to link two or more tables the data types are mismatched. Look over your relationships and make sure that the data types are the same. Cannot link a text data type to a number data type, etc.

Alan