create a report from tbl1 and tbl2

Hello,
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).
step3.
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
Example-101.accdb
davetoughAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I don't see how tbl1 and tbl2 are related, so it's impossible to know how the report/query etc should be built.
0
 
als315Commented:
May be you need only sheet of paper with all data from tbl1 and infomation from form frm1?
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
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:
ex:
tblCustomers:
CustID (Primary key)
CustName

tblOrders:
OrderID (Primary key)
OrderDate
OrderPrice
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...?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
davetoughAuthor Commented:
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
0
 
davetoughAuthor Commented:
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)
0
 
davetoughAuthor Commented:
delete that last comment- there is nothing in common here- and so far cannot add anything
0
 
Jeffrey CoachmanMIS LiasonCommented:
So are we good here?
0
 
davetoughAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.