create a report from tbl1 and tbl2

Posted on 2012-08-21
Medium Priority
Last Modified: 2012-08-22
I am attaching sample db- open database and a form comes up-
step1- user imports data into tbl1 - ( right now only a few records I am using for report).
step2-  user opens form and fills in 3 things.
(*note- the data that is imported is always from One date w/different times).
I am stuck here- I have created a template of report I need to produce-
is it possible from this data and way it is being created?
Thank you
Question by:davetough
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1200 total points
ID: 38317322
I don't see how tbl1 and tbl2 are related, so it's impossible to know how the report/query etc should be built.
LVL 40

Expert Comment

ID: 38317404
May be you need only sheet of paper with all data from tbl1 and infomation from form frm1?
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 800 total points
ID: 38317550
Like LSM, I am at a loss as to how these tables are related...

In order to create a report based on two tables, typically the two tables need to have at least one field in common:
CustID (Primary key)

OrderID (Primary key)
CustID( Foreign key)

In the above scenario, the two tables would be linked on CustID

How about you post an example of the *exact* output you require, based on the sample data you posted...?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 38317795
you are right - the reason I cannot do this is because there is no relation-
The lesson I need to learn is to not just say yes when manager asks for something -

thank you for pointing out the obvious

Author Comment

ID: 38317877
by  your answer it also helped realize- I can create a form and subform to complete this project close to what I need- thank you ( with minor changes)

Author Comment

ID: 38317986
delete that last comment- there is nothing in common here- and so far cannot add anything
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38318748
So are we good here?

Author Comment

ID: 38320077
yes--I have explained it will not work like this - and I am in process of figuring out how process can produce a unique Id

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

862 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