Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Making Queries Based on Table

Posted on 2012-03-29
5
Medium Priority
?
166 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 2000 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 2000 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 2000 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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 …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 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