If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pulling Client names from existing table to a pulldown on report prompt
I have a table of past jobs my company has worked on. A
feidl in this table is "client name". I have a switchboard setup with some reports on it. One of the reports is pulling all jobs by a paticular client. I want a way to add a pull down list of client names to this report so that you don't have to type in the name. So lets say I have 500 jobs and 50 clients, so there needs to be a pulldown with the 50 clients on it. Thanks! |
#2
|
|||
|
|||
Pulling Client names from existing table to a pulldown on report prompt
Create a query such that you can get a list of these
clients. Make it a 'totals query' so that you can use the "group by" to get unique names. Then add an unbound combo box to the form and in its "Row Source" put that query name. Alternatively, add an SQL statement to take the place of the query as above in the Row Source of this unbound combo box. With an SQL statement you can use the "UNIQUE" identifier instead of making a totals query. Example: SELECT UNIQUE ClientName FROM OldJobsTable WHERE... or SELECT TOP 1 ClientName FROM OldJobsTable WHERE ... HTH -----Original Message----- I have a table of past jobs my company has worked on. A feidl in this table is "client name". I have a switchboard setup with some reports on it. One of the reports is pulling all jobs by a paticular client. I want a way to add a pull down list of client names to this report so that you don't have to type in the name. So lets say I have 500 jobs and 50 clients, so there needs to be a pulldown with the 50 clients on it. Thanks! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Table with Subdatasheets reflected in a Report | Alcide | Setting Up & Running Reports | 1 | July 7th, 2004 04:23 AM |
What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- | Barry McConomy | General Discussion | 1 | June 7th, 2004 11:55 PM |
Macro possible? | Nimit Mehta | Worksheet Functions | 5 | June 7th, 2004 10:39 PM |