?
Solved

return subreport data based on multiple criteria

Posted on 2013-01-18
4
Medium Priority
?
462 Views
Last Modified: 2013-01-26
I have attached screen shots of the Access tables and queries involved.
I want to enter in the main form screen the "MMYY" and the "Broker".
Have the subreport return from the "CRInvNoCashApplied" query, the invoice numbers and cash applied, in that month for that broker.
Then to each invoice showing in the subform add "deduction amount" and "comment" to populate the CustDeductions table.
ProjectAccessCustomerDeductions.docx
0
Comment
Question by:actsoft
  • 3
4 Comments
 
LVL 31

Expert Comment

by:hnasr
ID: 38795724
If possible attach a sample database. Tell what to do to achieve the required result.
0
 

Author Comment

by:actsoft
ID: 38796471
I have attached a sample database.
The sample is all tables with samples of actual data.
However, most of my actual data comes from queries. Does that make a difference on the design?
I have also reattached, my original desired form layout.
Database8.accdb
ProjectAccessCustomerDeductions.docx
0
 

Accepted Solution

by:
actsoft earned 0 total points
ID: 38800933
I found the answer on AccessLearning.com
0
 

Author Closing Comment

by:actsoft
ID: 38821788
I found the answer elsewhere before a solution was provided
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question