My first suggestion is to go to make a backup of the database and then go to Tools (from the menu bar), Database Utilities and select Compact and Repair Database.

If that doesn't work, then I...

What you are trying to do can easily be done with a query. However, is the Style completely defendant on the code? If so, then I would get rid of the Style field and add a lookup to the code field;...

The way I've done this in the past is by using a dropdown box and then VBA to code what happens when a name is selected from the dropdown box. Here is the VBA:


Private Sub Combo1_Change()
...

From what you described, it sounds like the VLOOKUP function will work.

You give VLOOKUP a value, a range and a return column. The function will then look for the value in the range and then...

Is there a question in there?

You are trying to do too much with a single query. You will need to make two queries for what you are trying to do. Here are the two queries you need:

1) Group by Company, Count on Company. The...

When you mention a dropdown box, are you using the combobox control? If so, I would just use some vba.

However, have you tried using the Filter, which is found under Data of the Toolbar? To use...

Microsoft Access is sold with other Microsoft Office products as well as by itself. Since you already have MS Office, you would be interested in buying MS Access without the office suite. As far as...

Yes, you can have the x values as dates.

1) List your dates in a column.
2) List your y values in the column to the right of your dates
3) Highlight the Dates and y values and click on the Chart...

Here are the steps to making one cell display the information in another cell. When the source cell is changed, the cell that refers to it will change as well:

1) Click on the cell that will...