Search results for query: *

I have input approximately 1500 records into my database. Today I go into it and I can only find about 100 records. Does anyone have a clue as to where they might be? There is no update queries or anything fancy set up. Simple tables, queries and reports. Please help. The boss is going to have...

Am I losing my mind. I had to go from 2000 to Pro 2 weeks ago. Now when I try to create a report using report wizard I cannot group by more than three items and it picks the three to choose from(which are not the three I want to use). In 2000 I could pick many items to group by and whatever I...

SELECT [Special Sections].[Special Sections], [Special Sections].[Ad Rep], [Special Sections].Customer, [Special Sections].[Acct No], [Special Sections].Col, [Special Sections].[In], [Col]*[In] AS Expr2, [Special Sections].Color, [Special Sections].[COLOR=Price], [Special Sections].Price...

Thank you, I thought it might be the user because we had some trouble getting in onto the users computer. Our email at work has some type of securtiy on it that does not allow .mbd to be received via email. I had to change it to a .doc to email it and I thought this might have changed it...

All 8 salespeople can sale all products to only their customers or new customer in their territory. We have about four of these type of products every month. This was being done in excell which can be more difficult to use. I have set it up as follows... tbl-salesperson (lookup only)...

I have a table with only salespeople in it. (I use it for a "look up list" for another table. I also have a table with products in it (also used as a "look up list" in the other table).I need reports for each sales rep per each product. Should I establish a relationship...

I have set up a table with the Customers field pulling from a "list" to make input of info easier for the user. I then set up individual queries to pull for each salesperson and each product we sell. From the queries I used the report wizard to do reports. All worked fine on the...

Sounds like maybe you will have to re-format on the excel spreadsheet after you import. Excel see that as being a number, you have to tell Excel exactly what each cell is or it assumes it is a number. If you want it to be text as it was in Access then you may have to put an ' in front of your...