create a report from tbl1 and tbl2

Posted on 2012-08-21
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 84

    Accepted Solution

    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 39

    Expert Comment

    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
    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...?

    Author Comment

    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

    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

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

    Expert Comment

    by:Jeffrey Coachman
    So are we good here?

    Author Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now