Search results

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...

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...

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...

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...

Hello, I followed all of the steps to create a ranking field with a query and it works perfectly with one exception. Instead of the rankings beginning with the number "1" they begin with the number "0". Can anyone tell me how to make the ranking field begin with 1 and not 0? Here is the...

Hello Everyone, I've searched for posts regarding this issue and have only found old ones related to prior versions of MS Access. I'm using Access 2007 and I would like to create one form for data entry into multiple tables. Is this possible? I've attempted to add the fields from the various...

Hello, Can someone please tell me how to enter a decimal number into a text box, without the system rounding the number off? I have a text box, in a form that is based on a table column. It's formatted for number entry. I simply want to enter a number with three decimal places. I've tried...

I'm new to Access 2007. Can anyone please explain to me how to design a macro group to run a nember of queries in sequence or where I might find information that will instruct me in how to do this? Thank you.

Hello, I have a question regarding designing a query to obtain a specified single record or row from a table. Is this even possible? I understand top value and least value queries and filters. I've also done a lot of research in how to obtain a specified number of top or least value records. I...

Hello, I have a basic question: I'm new to access and I'm just learning about how to create macros. Can you please tell me if it's possible to run a series of queries by using a Macro that includes these queries in sequence? It's my understanding that you can run a series of macros in a group...

Hello, I'm not sure if this is a question specifcally for the tables board or for reports. But here is my question: I run statistics that are based on many queries and I need to store the results of the queries on a weekly basis according to the date the queries are ran. Is it best to store the...

Hello, I have a couple of ideas for how to accomplish this task. But I'm not sure what the best way would be. So, I thought I would present it to you experts. Here's the task: I'm currently filling various positions in my company, according to priority. Using the ranking positions of my...

Hello, After creating a new table, I based a new query on this table. I created the query on several fields in the query and added a calculated field based on these fields. Now when I attempt to run the query or even open the query after saving I get an error code asking me to enter the...

Hello, I have what may be a very basic question. When designing a software program, if you are calculating an amount, using the values of several fields in a table, would it be best to do a calculated field within an additional field in the same table, or to design a query with a calculated...

Hello, I have a form that I've designed to input information into a table. This information will be used to run many queries to obtain calculated statistics. On this for there are options that can be chosen by the user. These options will determine the formula query that will be run to obtain...

Hi, Was wondering if anyone has encountered this problem and how to resolve it. I've created a form that includes text box fields attatched to spin button controls. Everything works fine with this exception: The numbers within the text box, do not change along with clicking the spin button...

Hi, Can anyone please tell me the procedure for adding a 6.0 (SP4) Spin Button to a form in Access 2007? I've tried to follow the procedure that I've found for earlier versions. But when I click the Spin Button and pull down the property sheet, as instructed, there is no Control Source option...