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
|
|||
|
|||
"distinct" report data
Ref: Access 2K, SQL 2k
Is there any way a report can display distinct column data? I allow my users to filter the data in the report by a number of criteria -- this part goes into the filter string when I call OpenReport from VBA. Sometimes the results are lots of the same information from the RecordSource. I would like the record source to be "select distinct * ...) but I don't if there's a way to accomplish that without using a stored procedure. Thanks, William |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data on report based on current date | JenniferM | Setting Up & Running Reports | 4 | April 18th, 2005 10:45 PM |
Changing report data source | Marion | Setting Up & Running Reports | 1 | March 25th, 2005 01:56 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |