Creating Forms and Queries?

[jacob]

I don't know if this could be done but is there a way that a form can be
created where users type in Employee Info such as name or SSN and it
calculates the total number of vacation, sick and person time he has left.

I've already created the queries, but i don't know how or IF i can integrate
the two.

There are several tables
Employee
SickTime
PersonalTime
VacationTime

For each employee in the "Time" tables, a sum of their time taken and time
accrued is calculated to provide the total time available.

Thanks!

 

[Klatuu]

If you have a query working that provides the information you want, create a
form with the query as it's record source and include those fields you want
to display in your form. You could easily use the form wizard for this.

 

[jacob]

Well, actually the parameters for the WHERE clause will change.

How do you create a query with changing where parameters? I have the query
developed where the parameters are known.

Thanks!

 

[Klatuu]

How will you know what you want the parameters to be?

 

[jacob]

I want to enter the parameters into a text box. the user will then generate
the results. Or use a drop down box to view all employees in the department

 

[Klatuu]

If you use a text box or a combo, all you need to do is identify it in the
Criteria row of your query for the field you want to filter on. It has to be
fully qualified for the query to be able to find it. For Example:

Forms!MyFormName!MyControlName

The query will then use the current value of the control as its filtering
criteria