Recent content by Coach Ty

Hello, I'm new to access and I was wondering if anyone can please tell me how to structure a query, so that it returns information based on the true/false designations of multiple check boxes? I have an employee data base that contains various categories of information. What I need to do, is...

Here is the SQL Statement: # SELECT TOP 8 [Employee Table].Out, [QRY-Performance Ranking].[Date of Evaluation], [QRY-Performance Ranking].[Employee Full Name], [Employee Information].[ID], [QRY-Employee Performance Ranking].[Ranking], [Schedule Table].[All], [Schedule Table].[M], [Schedule...

I'm actually very new to Access, but I've learned a lot in a short time. The project I'm working on is really very simple, or at least I think it should be. The table that everything is based on contains the following column fielsd: Date, Emp. ID, Emp Name, and then the following check box...

I actually tried adding the ", Null" to the IIF statements but it returned a "0" in place of the check boxes that followed. I think the solution is to delete the IIF statements in the query, and filter the individual forms. But I'm not sure how to do it? Should I filter the query, using the...

The Scheduling table contains basic employee information such as name and scheduling date. Then it also has a series of check boxes that will determine job duties for that specific date. Included in this list of check boxes is one entitled "Out" for employees who will be absent on that date...

No I'm actually using Access 2007. It's very strange and it must have to do with the IIF statements that run the query. For some reason this process causes the check boxes, that are returned from the query, to not have the ability to be modified after the query. The queries that are run...

Hello, I'm wondering if anyone can help me with the following issue: I've based some forms on some queries. Some of the forms are based on queries that are straight forward, returning all records in the query results. Other queries are based on "IIF" statements and only return the results...

Thanks for your reply. The form is bound and it contains many check boxes that are based on multiple tables. So the form is set to "Dynaset (inconsistent updates)" I can see how your answer would clear one check box, but can you tell me how to design a single control to clear all of the...

Hello, I need to find out how to structure mutiple If/Then statements? I would like to base a query on multiple If/Then statements that are listed in sequence. The answer to the query will be based on multiple True values, that are entered into check boxes. For example: The answer to a...

Hello, I was wondering if someone can please tell me how to design a query that will clear or reset multiple check boxes on a single form? I have a form that includes multiple check (True/False) boxes. These boxes determine the steps that follow in the calculation process. I'd like to...

I have my data base almost finished, and I need to design two lookup queries that will retrieve specific record files. First, our employees are evaluated twice monthly in various performance categories. These categories are ranked in decending order, according to each employee's performance in...

Yes, just to filter one date of evaluation results.

Hi, Thanks for your response. What I have is a subform, within a form, that is based on a ranking query. The subform is in a data table format. The ranking query has a date field. So that every time the ranking query is done, an evaluation date is associated with the date the query was ran...

Hello, I'm working on an extensive data base and I've created the forms and subforms to bring up ranking information, in various categories. The information is dated with the dates of each evaluation. What I need to do is create a control that will return only the information for a specified...

Hello everyone, I was wondering if anyone can help me solve the following issue? I've set up a ranking field according to the MS Access help site and it ranks everyone in order, just the way it's suposed to. However, whenever there is a tie or several people with the same score, it lists them...