Access Form to Report

[microsoft]

Hi

As I am pretty new to access I will try to explain my problem as best as I
can.

Tables
Symbols - which contains the Symbol Description, Symbol Abbreviation, Currency
Trade Action - Buy, Sell
Trade Data - Gross, Net, Porfolio, Entry Date, Settle Date etc.


All tables are linked via a join relationship.

A form was created to capture all this information along with some other
fields not mentioned. The Symbol Abbreviation and Currency fields are locked
from the user. Once the user selects the description, these fields are
automatically populated by the database.

Objective
A report will be generated which shows the gross amount, porfolio, settle
date etc. However, when a user selects from the form, buy and the security
symbol is CAD, the subscription fee (CAD) on the report should be popluated
and when the user selects Sell and the security symbol is CAD the redemption
fee (CAD) on the report is populated.

How can this be achieved. I hope I have stated all the necessary
requirements in order to gain assistance. If you wish me to send a copy of
the project via email, please let me know.

Thanks and looking forward to hearin from you.

 

[Jeff Boyce]

With a bit more time in Access, you'll probably find it much easier to use
queries as your source for forms and for reports.

Create a query that returns what you need in your report. Base your report
on that query.