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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Drill down query problem
Hi guys, I am hoping someone can point me in the right direction with this problem. Query: SELECT AudMainOrders.Date, AudMainOrders.EnquiryNumber, [OrderNumber] & " " & [OrderNumLetter] AS OrderNo, AudMainOrders.Consultant...- cbase
- Thread
- Replies: 22
- Forum: Microsoft: Access Queries and JET SQL
-
Table design help needed
I have to design a databse that will allow multiple search criteria as below. Name Region Skill_1 Skill_2 Etc Now for the hard part, of the 300 or so names, 20 regions and dozen skill types, I want to return as an answer from a query the top X percent closest to the client request. To...- cbase
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
How to update table from imported data
I have a Table A in the main database that I require to be updated with information that is imported from the web and then placed in Table B in the same database. So far so good, I need to update Table A from Table B only when the primary keys match. In addition I would like to monitor/record...- cbase
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
