I'm trying to have a sql stmt in my query where I can pull data for a certian group of individuals. I have other expressions and criteria in it (that is...

I am working with MS Access 97, with a SqlServer linked tables. I need to append data from tblA to tblB, both of them link tables. I created a new Append...

I want to query 2 tables from 1 form. the query SELECT ., ., ., ., . FROM STUDLIST INNER JOIN SignedOutEquipment ON .=.; Works fine and the query

In the following there can be more than one (uniq_id) for the caseno in dbo.master. I need the max(uniq_id) or last per caseno. I can do it when I am only...

Any guidance or help is very much appreciated. I have 1 table with the following fields: NetSales, Vendor, Customer Name, Period, etc; I originally tried to...

I need to use a crosstab query with a "parameter query" (user enters dates) and understand that I must define the parameters in the crosstab query - but...

I have a field with records that are in this order Location1 - Material Name Location2 - Material Name Location3 - Material Name I would like the query to...

I am using access 2003 My query has 3 tables t040Project (PK ProjectID) t052OrdNoDetails(PK OrdNoDetailsID FK ProjectID) 1 to Many t51KeyMilestones(PK...

How would I create an update query to update a field in a table from the results of another query? First I have this that gives me the total number of...

I am new to SQL Query so there is probably an easy answer to this question. I posted a question the other day which gave me this query; SELECT Order.Order...

I am trying to use fConcatChild and am unsuccessful. I have a query that uses a value from a form along the way that has a list of scheduled tests during a...

I am attempting to have a query from two separate linked tables. Both fields I am trying to join are all numbers, however Table1 has this stored as Number,...

I'm trying to do a crosstab query, that will show multiple values on each row, in separate columns. so, I want to display the following: Month Completed ...

Can anyone solve my problem .... In query there are 3 field - Mark1, Mark2, Mark3. I like to do an expression that we can choose the highest mark and second...

Hi Guys, I have a database that contains a table called Tenant that has a field called Address and also a field called DateVacated. What i want to be able...

Could someone help me document this code so me, the newbie can learn something? I tried to document what i could. Andrew Here is some code I am trying to...

Hello, I am doing an inner join query. Typically, you would match up the ID's and away you go. I have a query that is a little different. I now have to...

I have a TransactionsTbl which records which Item is with which User (TransactionID, ItemID and UserID). The problem I am having is that when a new...

Greetings, I have 10 DELETE queries set to remove data based on the MONTH field. The month to be deleted is stored in the Criteria. My question is, is there...

I have a table that contains transaction records. I need to summarize revenue of transactions by transactions source. I can do this creating a Report from...