Search results

I am trying to create call lists which will compile one-to-many relationships. For example, suppose I have 1000 employee records with the following fields: Manager's Name Manager's Phone Number Direct Report's Name Direct Report's Phone Number Each Direct Report has only one designated...

I am trying to create call lists which will compile one-to-many relationships. For example, suppose I have 1000 employee records with the following fields: Manager's Name Manager's Phone Number Direct Report's Name Direct Report's Phone Number Each Direct Report has only one designated...

With the imense help of some of the people in this forum, I have scraped together a nice little database. There is one function, however, which is not working. I have a query that should run from a form I have created. The form has multiple criteria and all seem to be working except for the...

I have a form in which old customers can be edited and new customers can be added. Currently, to edit a customer, the user clicks in the "Last Name" field and then selects EDIT-FIND and types in the last name. The user will then cycle through all customers with that name to select the correct...

I am trying to put together an form to be used in an academic administration database. Ideally, I would like to create a form that will allow a user to select criteria and get a list of all students fitting that criteria. For example: Show me all a) all Economics majors with b) 30-50 Credits who...

I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward. One large problem I have is that the product descriptions are roughly 700 characters. Is there...

I have a table with 20,000 names in column 1. Columns 2-8 are Yes/No questions. I would like to set up a query to see how many people answered Yes for any combination of questions. I think a crosstab is needed, but I just can't for the life of me think how to do it. Any ideas?

I have a large data set with values ranging from 1-25,000. I would like to be able to calculate how many entries there are in each increment of 10 (1-10, 10-20, etc.), then perform the same query for each increment of 100. Any ideas?