Recent content by ms_access_00

:-) I thought you might ask this. I don't own or have admin rights to the SharePoint list. Someone else does. I just need to get certain data from the SharePoint list. I have it as a linked table to a MS Access table so that I have a live connection to that SP list. This allows me to run a make...

Because I have an excel file with a macro that reads the table from Access. Or can I do the same thing with a Select query??

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...

Thanks for you reply. Just to clarify what you are saying. Do I need to create two separate queries to complete my request? Is it possible just to use one query?

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...

Thanks :-)

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 was hoping to do the query itself in a MS Access query using the Query Design. Is the above VBA code?

Yes it is set up correctly. I am looking to count across a row, that is correct. Once it counts across certain feilds in a row it then populates another fields with the count number on the same row.

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--------------------...

Thanks for your reply pr2-eugin. That is great. What is the best way to then update the table with this query so that the the Latest Date field is populated with it.

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...