• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

Making Queries Based on Table

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
gigifarrow
Asked:
gigifarrow
  • 3
  • 2
3 Solutions
 
als315Commented:
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
 
gigifarrowAuthor Commented:
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
 
als315Commented:
You are limited only by size of your db (less then 2 Gb). You can have one big table or many -  no difference.
0
 
gigifarrowAuthor Commented:
Okay, so how do I do what I have asked in my original question Using seperate tables ?
0
 
als315Commented:
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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now