Is It The Queries Or Tables?

Jul 7, 2006

Hi,
I am having a problem with my queries or tables... I am not even sure which of the two I am not doing right.
The test query I have written is really a simple one so I am not sure if anything can wrong with it.
I have 3 tables with one - one to many relationship
and 1 many-to-many relationship (IN access it's 3 entities + 1 relationship tables).
All I am trying to is to see "conclusion_id"s associated with "INT_Reg_no" used in query.
For example I want to see "conclusion_id" associated with "INT_Reg_no" 1.1.
When I put this in I should get 2 conclusion numbers (Conclusion_id 1 and 2) but I only get one (Conclusion_id 2).

Can someone help me with this?
Thanks,

J

View Replies


ADVERTISEMENT

Tables :: Lock View Of Tables And Queries?

Sep 24, 2013

I want to lock the view of certain tables and queries so that users could not perform any change at their own. Is there any way in VB to protect it with password....

View 1 Replies View Related

Linked Tables Or VBA SQL Queries

Dec 1, 2005

I am new'ish to access, although we have had an SQL server 2000 backend for some time, it has purely been used for our MIS systems, now I want to develop using Access 2003 as the front end, and SQL as the backend, however, I don't know the most effective way to link to the data on SQL, I can use either linked tables through Access, or not use linked tables and just send SQL queries to the server using vba code, I am not sure which would be the best solution to creating a new application.

Any ideas whether I should use linked tables or fire off vba SQL queries ?

cheers
John.
:confused:

View 1 Replies View Related

Knowing Which Tables Are Used In Queries

Feb 18, 2006

Hi All,

Is there any standard Access functionality which can tell me which tables are used in each of my queries.

Failing that has anyone ideas on some query I could develop or code that I could write which would give the required output.

Thanks,

Evan

View 1 Replies View Related

Populating Tables And Queries?????

Jun 29, 2007

I have created a query from two tables. One table is Job information the other is job notes. How do i populate the query with the job # and job prefix from the job information table? I have the query(field) structure I want but its just gives me blank fields in the query form. How do I populate the fields with the info from the tables?

Thank you!

View 3 Replies View Related

Find Queries From Tables

May 10, 2005

Ok this might be a really stupid question, but in the quest to always make my life a little bit easier thought i would ask !

I have been asked to find the relationship between a number of tables and queries, so that this company can find out which tables and fields in tables are no longer really used, in other words how many queries and which ones is table A used in if you understand what I mean !

doing it manually means checking every query (and there are a lot !!) and seeing which table they use.. what I want to know is what is the quickest way to to this? can I do it from the table end? in others find out how many queries Table A is used in ? or do I have to go through each query individually? if this is the case my thoughts were just on copying and pasting the sql view from every query into a a word or txt doc and then doing a search /find for each table name? but if anyone has a more efficient idea on how to do this if u cld let me know !! :confused:

View 2 Replies View Related

Changing Name Of Tables And Queries

Jul 12, 2005

Hello Friends
I have 100 tables and now I changed the name of tables due to some reasons. Now I must to replace the names in other database objects.Is there any option that can reduce the work load because otherwise it is a tiring job to replace it manually.

View 4 Replies View Related

Lost All Tables And Queries

Apr 18, 2006

Not sure what happened here.
I now have an empty (277MB) shell in which I cannot see any tables or queries.
The event occurred when the db automatically began to "Compact and Repair" in the middle of creating a new query. Any thoughts?

View 5 Replies View Related

Lookup Tables And Queries

Aug 22, 2006

I have a database that has been developed by a consultant. Unfortunately the database contains look-up tables. Obviously when I query it returns and references the codes for the lookup field rather than the lookup field value. Unfortunately I am unable to change the database to remove lookup fields/tables. How can I get around this to produce tables with the lookup field value or perhaps reproduce the old tables (without just cut and paste) to then conduct my queries. Am I missing something simple as I am fairly new to Access development.

Regards,
Deesy.

View 2 Replies View Related

Combining 2 Tables Into 1 Using Queries

Nov 13, 2006

I've been asked to make a DB for our production. We have 2 sources, of which have similar field names and collect completely different data, but can not be linked. I don't want them to be linked either, I don't think. The only thing I want to do is to take the 2 tables I have from my 2 sources and combine them into one. I'm using the first table in a make table query and then creating blank fields in the query also, so I can append the data from the second source in the "all production" table. The only problem I'm running into is that I can only get to 26 fields in the make table query, I need 31 fields to get everything. I tried creating a new query and not using any tables, and I was able to get to 16 fields. Is there something I'm doing wrong, or is there another way I can get a table created will all fields I need and append the data from both sources? I would need to be able to re-run this daily which is why I was trying to do it through a query. Thanks for any help/ideas. It's greatly appreciated!

View 5 Replies View Related

Queries Using Tables W/o Links

Feb 20, 2008

I have a query where I am trying to set the where criteria expression using an unlinked table. The unlinked table name is INV DATES. The criteria field is [THE_DATE]. I cannot really link the fields for the two tables since I am using an expression. This design works, but it goes really slow.

Any ideas?

SELECT DISTINCT DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER, DSSAPP_FULL_WIP_PROD_STATS.OPERATION, DSSAPP_FULL_WIP_PROD_STATS.OPERATION_START_TIME, DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME, DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY AS QUANTITY, DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY_TIME AS [DATE], DSSAPP_FULL_WIP_PROD_STATS.LOT_HOLD_FLAG, DSSAPP_FULL_WIP_PROD_STATS.ACTIVE_FLAG, [INV DATES].THE_DATE, [INV DATES].WEEK_NUMBER_IN_YEAR, [INV DATES].MONTH_NUMBER_IN_YEAR INTO ROXES
FROM DSSAPP_FULL_WIP_PROD_STATS, [INV DATES]
WHERE (((DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R1*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R2*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R4*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R5*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "RR" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B0*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B1*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B2*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B5*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B4*") AND ((DSSAPP_FULL_WIP_PROD_STATS.OPERATION_START_TIME)<=[INV DATES]![THE_DATE]) AND ((DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME)>[INV DATES]![THE_DATE] Or (DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME) Is Null) AND ((DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY_TIME )>=Now()-600) AND ((DSSAPP_FULL_WIP_PROD_STATS.FACILITY)="STPPRD" Or (DSSAPP_FULL_WIP_PROD_STATS.FACILITY)="EPIPRD"))
ORDER BY DSSAPP_FULL_WIP_PROD_STATS.OPERATION;

View 1 Replies View Related

Comparing 2 Tables Or Queries

Nov 8, 2004

I have 2 tables. Quotation Details and Order Details. As you fill in the Order details Form I wish to compare fields from the
Quotation Details Table. Is this possible? Please advise.
Thank you.

View 1 Replies View Related

Queries, Tables And Forms?

Mar 2, 2005

I currently have a query and a table which I'd like to create a form for. The query has people's information in it and the table has RSVP information in it (if they need parking, etc.). I'd like to create a form so that I can type in the person's name and then it brings up their address (just to confirm it's the right person) and then i can enter in the RSVP information. Any suggestions?

View 14 Replies View Related

Upgrading Tables & Queries

Feb 17, 2008

I have several clients using the same database structure. If I do any upgrades or mods I currently manually add the new fields to each database. Is there an easier way?

Is there an easy way to upgrade a whole MS Database based on another? Can I either import just the new structure and not duplicate tables; or export and then import to my new blank database with the new structure?

View 5 Replies View Related

Queries :: Bring 2 Tables Next To Each Other Without ID?

May 24, 2013

I`m trying to put 2 identical tables in terms of structure and layout with some identical values next to each other however I don't have unique identifier. I was thinking to import them and let access to create Id field and match them together but i wasn't successful because for some reason access changed the order of some rows. Good news is that when I import these text files into excel Im able to put them next to each other in order. How this could be achieved in Access?

View 4 Replies View Related

Queries :: Pulling Together Several Tables?

May 2, 2014

I have datasets in tables for some price data, which is monthly. Each month there is a list of unique ID codes for the products ("CAP Codes") and then a price for that product ("LM Retail").The table names are simple dates (2010 01, 2010 02 etc) I want to have a query which would create a table which follows the price of each product through the months. All of that would be simple except not all of the products appear every month, so when I set up a simple link between them all it only outputs products which appear every month. Is there a way that it'll keep the products with just some prices - leaving a blank in the table created when there isn't a price that month?

View 3 Replies View Related

Queries :: One Query For Many Tables?

Apr 3, 2014

How to make 1 queries for many table

example :

Table 1
name Status
john Ok
mike No
Ann OK

Table 2
Name Status
michel Ok
jony Ok
Bruce No

Queries for OK

Name Status
John OK
Ann OK
Michel OK
Bruce OK

This is just simple example, actually i have many table January until December. So when i key in data using form on every month, I want just 1 queries covering all month, so easier to check.

View 13 Replies View Related

Queries :: Merge Two Tables

Sep 5, 2013

I have a database with the following tables:

- data
- datamodifications
- mergeddata

The "data" table is imported from a large excel file (about 5000 rows and 40 columns) and needs to be updated about once a year. The idea is to use the "datamodifications" table to store all modifications and then merge "datamodifications" and "data" into "mergeddata", so when i have to update the "data" table next year i can just remerge it with my modifications. My problem is that i cant merge the two without getting dupliace entries. I have tried with this query but it gives me duplicate entries:

Code:
SELECT col1, col2, col3
FROM data
UNION
SELECT col1, col2, col3
FROM datamodifications
ORDER BY col1;

How can i remove the duplicate entries (or is there a better way than actually writing SQL to do what i want do to?

View 4 Replies View Related

Queries :: Two Tables And Two Columns

Sep 17, 2013

I have two tables which I need to change stock levels. I have one table that has the stock levels as of now and another table that shows stock levels from yesterday. I need to produce a txt file so that it checks both stock levels and if the NOW stock level is different to the Yesterday stock level it shows only these items so that I can update them.

View 1 Replies View Related

Queries :: Referencing Other Tables

Jul 22, 2015

The code below bring back the results I want however.....

SELECT dbo_MF_PATIENT.Forename,
dbo_MF_PATIENT.Surname,
dbo_MF_PATIENT.DOB,
dbo_MF_PATIENT.Postcode,
Count(dbo_MF_PATIENT.HEYNo) AS CountOfHEYNo
FROM dbo_MF_PATIENT
GROUP BY dbo_MF_PATIENT.Forename,
dbo_MF_PATIENT.Surname,
dbo_MF_PATIENT.DOB,
dbo_MF_PATIENT.Postcode
HAVING (((Count(dbo_MF_PATIENT.HEYNo)) > 1));

My issue is I want to run this bit of code but only if the dbo_MF_PATIENT.MFPatientID appears in any of the 3 tables below:

dbo_ED_ATTENDANCE, dbo_OP_APPOINTMENT, dbo_IP_ADMISSION

Suppose im unsure on the joining because there is only ever one patient in the dbo_MF_PATIENT table but they could appear dozens of times in any of the other 3 tables.

View 3 Replies View Related

Is There A Way To See The Links Between All Tables, Queries, Reports?

May 20, 2005

I was recently doing a little Spring Cleaning in my database and deleting old tables and queries that were no longer used or had been for experimental purposes. Unfortunately, I unknowingly deleted a query that was being used by a report I still needed and it took me several hours to find and correct the problem.

Not wanting to repeat this mistake, I began searching for a way to display my reports, queries, and tables and all the objects each is linked to. I thought it would be nice, for instance, to have a hard copy list of all my queries that showed where they are derived from and what other objects reference them. Is there a way to do this?

I've tried using the "Relationships" button and working with the Documenter, but I haven't found what I'm looking for. I have also tried a Google search, but, admittedly, I may not be using the proper terminology to get good results.

Thanks for your time.

View 4 Replies View Related

Reports And Queries Not Getting Data From Tables

Jun 17, 2005

Hi all,

I'm trying to create a database to track all the students details, I've created the data base with all the tables, relationship etc. i tested it with dummy data too and it worked fine.

I then imported the proper data from a .csv file, using the "File-Get External Data-Import" method rather than a macro, it imports the data with a couple of errors but the data still got through, i had previously created queries and reports and they worked fine with the dummy data but will not show any of the new imported data, its like it hasn't got a link or something but if i create a linked form, it will pick up the data, meaning the relationships are working. hence my problem

Thanks

Dellero

View 2 Replies View Related

Using Queries To Alter The Structure Of Tables

Aug 2, 2005

How can I add an additional field to a table based on the output of a query? For example, I have table A with 2 types of records and table B with only 1 type of record. Based on this, I can determine which records in table A are the same type as those in table B. I would however like to be able to flag within table A, those records in table A that are the same as those in table B.

View 1 Replies View Related

Deleting Multiple Tables Or Queries

Mar 6, 2007

Hi.

I have a cluttered database with too many 'no longer necessary' queries and tables.

Is there a way (other than deleting them one at a time) to delete multiple ones at once, as I can in My Documents, et cetera?

Russ

View 2 Replies View Related

Remove Redundent Tables And Queries

Mar 9, 2007

i have just taken over

I have just taken over some database which have a load of tables and queries that I suspect are no longer requirer. Is there anyway to see when a table or query was last USED in a database??

Any help is appreciated

View 1 Replies View Related

Stop Users Using Tables In New Queries

Apr 27, 2007

Hello all,
I am setting up an access 2003 database in a Client/Server configuration. All dat entry is done through queries, forms are not used. I am wondering if it's possible to prevent users in the client database (Or a copy of it) from creating new queries that hang of the linked tables. I want them to hang new queries only from existing queries. This way I can be sure that what they see is always appropriatley filtered. Any ideas?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved