Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Special query
Hello, I am trying to use a command button on a form to allow a user to run a make-table query. The query is the problem. I have two tables, I need all the data from table A but only certain columns from table B. Both tables have a company_id that is used for the relationship. I can't just say...- lfarina
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Need help with code to flatten table
Hello, I have to denormalize/flatten a table and I can't get things to work correctly. I have a table called PERSON which contains contact names and titles for certain companies. There are three columns in the table - Company_ID (which is the primary key), Fulnm (which is the contact name)...- lfarina
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Table Design Data
Hello, I need to create a report that shows the field names, types and sizes within a table. I know I can run the Documenter to get this info but I need to create a separate report that shows other info too. Is there another way to get that type of info about a table without having to run...- lfarina
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
