I have two tables. The first contains 2 columns, ID and Name: 1, John 2, Mary 3, Bill 4, Troy The second contains ID references to the first

Hello I'm trying to create a query with A JOIN clause that is using LIKE. The problem : In table A I have international phoned numbers like this...

I have the following query joining two tables (with 2 matching fields). So far so good : SELECT tblCatMaps.SeriesId, tblCatMaps.Number FROM tblCatMaps INNER...

I have a table(A) that is joined to 2 other tables (B and C). The Key in all 3 of these tables is Part. Part 123 in on Table A 1 time, on Table B 3 times...

i need to add a yes/no field to a linked table. i would like to create a query that would join a table that contains the yes/no field to the liked table. i...

Dear NG, I'm very new at queries, and as you'll see here in a second - my queries show it! I've created 3 queries to do what I feel certain can be...

Could you be so kind to give me an example about the theory you posted, please??? "Ken Snell" escribió en el...

Is it possible to have a query that joins two tables where table1 may not have a matching record to table2, and in this event you could CREATE the matching...

I have been trying to write an SQL query in Access--which unfortunately does not support full outer joins, although I think the problem goes beyond that--that...

I have two tables with the same structure. One is an archive of records from the other, but there is an occasion where both need to be searched for an item...

I'm working in Access 2000 on converting a client's spreadsheet to a database. In the simplest terms, there are two sheets, one with mothers' names and...

I have 2 tables (hard to list down all attributes , so i give an example) Table 1: Name Nationality Birthday nickname school allen...

I created 2 tables and created a relationship using ID#, 1 to many. I used both tables in a query. I can filter in the y/n box for yes, but not for no. I can...

I am new to access and am trying to create a query that joins the first and last name in a table to create a new field called fullname that has the first and...

Trying to incorporate 2 left join queries into 1 combined query. Basically I'm trying to get the total REG hours and OVT hours for each pay period and each...

I have 2 queries: Query1 SELECT (count(TradeVolume)/2) AS TotalVolume FROM HILLTOP; Query2 SELECT (sum(TradeVolume)/2) AS TotalVolume FROM HILLTOP;

I have two queries that I want to join. I want to use SQL so that I can eliminate the queries how would I do this? Query 6 SELECT tblChecks.ChkTabID,...

Hi, I have problem to make query for joining 2 table, first table (tblA), holds num data which associate with date, while second table have date with interval...

I have a control table(pay_period) with 1 row and 1 column called pay_pd_id the value is '070105'. I'm trying to join to a table with many rows for the same...

I have 2 tables: 'tblAssetCatLinkBackup012501' and 'tblAssetCatLink'. Both tables have a field called 'asset'. I want to see which assets in...