Multiple Copies of Reports

[Guest]

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]

Are you using the combo box to filter your report? If so, how? Are there
multiple records in your table for each SecurityExchange?

 

[Guest]

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?

--
Duane Hookom
MS Access MVP

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]

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.

--
Duane Hookom
MS Access MVP

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?

--
Duane Hookom
MS Access MVP

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.