Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

Multiple Copies of Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
microsoft - 28 Oct 2005 04:38 GMT
Hi

I created a form to allow users to enter trade ticket information.  I have a
combo box where users select the Security Exchange description from the drop
down and the associated symbol  appears in the text field.

Table: Exchange
Cound Column = 1
Column Count = 2
Row Source: SELECT [SecurityExchange], [Description] FROM Exchange ORDER BY
[DESCRIPTION];
Column Width = 0"; 2"

I have a query created which pulls all the necessary fields from the table
and creates a report.

The problem is as follows
Based on the entry date of the ticket the report displays the results
however eg. if one ticket was entered on October 27th 2005, 14 copies of the
report are shown.  The 14 copies represent the 14 records in the exchange
table.

Why is this happening and what can I do to rectify this?

Thanks so much for your assistance.
Duane Hookom - 28 Oct 2005 13:26 GMT
Are you using the combo box to filter your report? If so, how? Are there
multiple records in your table for each SecurityExchange?

Signature

Duane Hookom
MS Access MVP

> Hi
>
[quoted text clipped - 25 lines]
>
> Thanks so much for your assistance.
microsoft - 28 Oct 2005 15:17 GMT
I am not using the Security Exchange combox box to fileter the results for he
report.  Hence why I am so puzzle why I am getting the 14 reports based on
the number of entires in the Exchange table.

They are 14 records please see below for a small expample

Secrity Exchange                       Symbol
Canadian Exchange                   CE
Nasdaq                                    NS

Thanks I hope this makes it a little clearer

> Are you using the combo box to filter your report? If so, how? Are there
> multiple records in your table for each SecurityExchange?
[quoted text clipped - 28 lines]
> >
> > Thanks so much for your assistance.
Duane Hookom - 28 Oct 2005 22:09 GMT
You seem to have a problem with a report but you haven't provided the record
source of the report or how you expect it to be filtered. You mention
something about a date but didn't suggest how it had anything to do with the
report.

Signature

Duane Hookom
MS Access MVP

>I am not using the Security Exchange combox box to fileter the results for
>he
[quoted text clipped - 46 lines]
>> >
>> > Thanks so much for your assistance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.