Recent content by fvreg

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

I have attached a screenprint for you to get an idea of how I think the form should ultimately look.

To hopefully answer your questions more fully: I have a table with 2 columns, min date and max date. The min column has month beginnings (1/1/05, etc.) and the max has month end (1/31/05, etc). My form then has a list box for Last Class Taken Min and Last Class Taken Max, which lists the...

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

This looks promising. However, between my minimal knowledge of VB and the language barrier, I am having a hard time adapting this to my form. Is there a tutorial somewhere that tells me what each of these steps does?

That sounds something like what I need to accomplish. Unfortunately, as an Access beginner, it seems to be a little over my head.

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

many thanks. I have not used this feature in the past.

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 think I have it, actually. Many thanks.

I appreciate the help. This looks like a great idea. Unfortunately, I am new to SQL and having a hard time with the syntax. Any chance you could help me out?

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?