Solved

Making Queries Based on Table

Posted on 2012-03-29
5
162 Views
Last Modified: 2012-04-02
Query
I have a database that I just started working on. There are several Queries That I need For each table.   I need to have a parameter querie that defines each "state" fields. So when you come to the query it will prompt you to put in the state. The query then searches each table to find that state. That information is then shown. I need a query that will show the date recived, based on the date.

Report
I also need a report for that query to show the information of each state requested. I also need the report to show all the  states but each state on a different piece of paper. Enclosed is my database that Im working on.
Shipment-Tracker.accdb
0
Comment
Question by:gigifarrow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 40

Assisted Solution

by:als315
als315 earned 500 total points
ID: 37782354
Not very good idea to have many tables with same structure for different locations. May be you can join them to one table with additional field: "Location"? Is it a combination of separate DBs?
0
 

Author Comment

by:gigifarrow
ID: 37782394
All the column names are the same for each table . Do I have enough room for all those tables in one table? Each state has a table.
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 500 total points
ID: 37782421
You are limited only by size of your db (less then 2 Gb). You can have one big table or many -  no difference.
0
 

Author Comment

by:gigifarrow
ID: 37782529
Okay, so how do I do what I have asked in my original question Using seperate tables ?
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 37783079
As a temporary solution you can use union query, where you can "join" your tables into one.
Remove additional fields (state in table "tblAnniston AL") and use query like this:
SELECT *, "Aberdeen" AS Location FROM [tblAberdeen MD]
UNION SELECT *, "Anniston" As Location FROM [tblAnniston AL]
UNION SELECT *, "Iraq" As Location FROM [tblBIAP Iraq];
You can add all tables to this query
0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses

623 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