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
Solved

Making Queries Based on Table

Posted on 2012-03-29
5
154 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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

856 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