Search results for query: *

Hi to all, I have a form with two list boxes(miltiselect). First box I want to allow user to select one or many offices, second box I want user to be able to select one or many job titles. My code below works ok when one selection of office and job title, but not working correctly when...

Hi to all, I am working with student performance data by school district for grade 3-8. The data is both for English and math. The data came to me in one complete table. I had to break it out by school district, type of test, english or math, and then by grade level. So I have 6 tables for...

Hi, I need to find a way to create one record for many records for the same school district. I have many records that I get from the state. School district name and total experience and a salary for that exerience. 1 year of experience, count of 3 people, salary of 32,000. Here's the data...

Hi, I'll try to setup my question. I have a form with a 2 listboxs(multiselect). The first listbox I want to allow the user to select the report to run, 1 or up to 12 different reports. The second list box I want to allow the user to select a office, 1 or up to 16. The report source is a...

Hi, The user has changed/added more items to what I thought was a completed item. Here's the setup: Form was designed to select a Office, using a listbox from a table. Same form they added a listbox for jobtable, linked again to a table. There is a seperate report for each job title, 12 in...

Hello to all, I currently have a form that allows a user to select a school district and then previews that school districts data in a report form. That has worked fine for a while now. We are starting to get large requests in and we now want to be able to batch process the lot. Allow the...

Hi, Can you create a relationship from one table to another based on only part of the field? Example = Table 1, Field name = "Berlin TA" Table 2, Local Name = "Berlin Teachers" I want to link based on "Berlin" Thanks, TC

Hello to all, I have two tables. I want to update a field based on the name. Problem is the name in table 1 and the name in table two are not exact matches. Example: Table 1 = Name field= Berlin Teacher Assoc., table 2 Name Field = Berlin TA. I want to take the local number from table 1...

Hi, I have 10 reports that are based on a different queries. When that report is selected I want the user to be able to select one office and get the results or all offices and get the results. I have an input in my query, but now I want to have one form that has a list box of the office...

Hello to all, I have a parent table, main contract information. And then a child table for salary data for each year the main contract covers. A one to many. I want to develop a report like this: Clerk/Typist Salaries County District 2005-06 2006-07 2007-08...

Hi again, Great site, great folks. Users want to handle data entry this way: A yes or no choice for a field, but they want it to be blank first, how do I do that, field options? Currency field, want it to be blank when starting data entry. Thanks, TC

Hello to all, Have a parent table with a child of salary data. The main form has the parent record, sub-form has the salary data for that parent. What's the best way to allow users to delete a sub-form record? Thanks, TC

Hi, I want to know how I can update a rank field with the results of my ranking query. Here's my query statement and it works great when displaying the query. ranking: (select count(*) from Tab_tc where [percent_L3_L4] >[emp1].[percent_L3_L4];)+1

Hello to all, I am at a developers block or just stuck, or maybe just stupid. With that said I have a question(s)on best approach method. Users have a collective bargaining agreement(CBA) database. It lists info about the CBA, years covered, who CBA covers, type, etc. They now want to add...

Hi, Here's a questions that may sound dumb, but here goes. Why use a subdatasheet? Why not just link two tables? Thanks to all that reply. TC

Hi to all, Very new to access 2003. I'm looking for suggestions on how to approach this assignment. Here's the setup: Table in access that contains Labor union contract information, name of local, county, regional office, type, years contract covers, etc. User now wants to add salary data...

Hi To all, Here's the question: I have a master contract table, it contains information about the contract, years covered, local type ext. I have a field(Yes/No)called teaching assistant in the contract table. I have been tasked with creating a salary table now that would contain salaries for...