Search results

Hi, I am trying to run a make table query that involves using a linked table in Ms from a SharePoint list. However, a few columns I wish to include in my Make table query are calculated columns from the SharePoint list. The make table query will not run saying "Calculated columns are not...

I am trying to retrieve data for a particular record. When Project field matches a certain project number I want it to pick the record with the latest date in the date field field to select certain data fields(Owner & Rating) from that record. Below is my attempt. However the problem is that...

I am trying to run an append query but I am having trouble with it. I am trying to append records from one table to another table. Only two records should append to the "FixedTable" but 6 records get appended - (3 records identical of each of the records from the "TestTable1). See code below...

I am having trouble with a select query I am creating. I am only trying to show the number of records with a certain "status" and that the "provider" field begins with KGF and the "Discipline" field isnt equal to PRB. SQL Code: SELECT [Overall PRB Tracker].Provider, [Overall PRB...

I am trying to write a query to count the number of entries across 4 different fields for each table record. For example: Project Code------Date1----Date2----Date3----Date4 RS1234-----------2Jun-----8Jun------9Jul------19Jul DF1345-----------7Apr-----9May--------------------...

I have 4 columns that I am trying to get the greatest value for. I am using the following query: UPDATE TestTable SET TestTable.[Last PQC Month] = IIf([PQC1] Is Null," ",IIf([PQC1]>=[PQC2],[PQC1],IIf([PQC2]>=[PQC3],[PQC2],IIf([PQC3]>=[PQC4],[PQC3],[PQC4])))); However, the query only updates...

Hi I have a table with a 200 project codes and four seperate date fields for each project. For example: Project¦ Date1 ¦ Date2 ¦ Date3 ¦ Date4 ¦ F12345 10/01 24/02 04/05 19/07 Not every date will be populated. So some...