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!
-
Limit on "league table" subreport without using TOP
Two queries, two reports. The first query takes a company name as input and returns all towns in which that company has an office. The second query returns company, town(ie office location) and number of orders, ordered by number of orders descending. The first report is based on the first...- Henryp
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Norton Adblocker removes CreateWindow button
On my site there is a button that pops up a response form box. It uses the CreateWindow command to position the box and determine the size. It pops the form over the launch page. However, it only operates when the button is clicked, so it's not an intrusive popup ad or similar. PCs with certain...- Henryp
- Thread
- Replies: 1
- Forum: Javascript
-
possible settings problem - data "missing" on one PC, not another!
This is probably a really stupid question. Two users looking at the same database (linked tables), read-only. One sees all the contents of all the tables. The other has data missing in two fields in one (of many) tables. I say missing - the fields appear to be empty, exporting them produces a...- Henryp
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Concatenate data from field where one-to-many relationship
There are three tables to allow individual addresses to have multiple types. What I would like is to produce output that has one address per line, with the types listed for each. Here are the table structures: Table 1: Addresses AddressID (123,124,125,126 etc) AddressLine1 AddressLine2...- Henryp
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
