Search results for query: *

I am having issues converting a text field to a date. I am using a table that is linked to a text file with the dates in the following format: I am using Access 2003. DTS 7/26/2007 7:06:05.000 AM 7/26/2007 7:06:05.000 AM 8/1/2007 7:06:28.000 AM 8/6/2007 7:05:27.000 AM I want the result in my...

I have two tables with a left join on Provider ID. I want everything returned from the 1st table and then all records from the 2nd table where the Provider ID matches. The problem I am having is that I need to set a limit on the 2nd table to only reuturn "Active" providers. But when I add...

I need to delete records from one the tblworkingtable. I am able to select the records to be deleted --however everytime I try to put it in a delete query I receive an error (e.g. not an updateable query) I have attached my select query that works.. but I am at a loss of where to go from...

Hello, I am trying to write a query that lists only the most current record for each provider ID. The query does not work when 2 statuses have the same effective date. In this case I need the Max date and the Max Order. I have tried several iterations for the query, using a top 1, a...

Hello, I am trying to write a query that lists only the most current record for each provider ID. The query does not work when 2 statuses have the same effective date. In this case I need the Max date and the Max Order. I have tried several iterations for the query, using a top 1, a...

I have searched the forum and tried to model my query after very similar queries, and I am having problems. I am trying to return the record with the most recent Status Date. I have created a query StatusUpdate that combined two tables Provider and Status. Then tried to create a query to find...

Please Help. I need to write a query that will return the record FS number that is used the most often for the TIN. So for example I have the following table tblOAFeeScheduleListing T30 Tin Nbr T46 Fs Nbr CountOfT46 Fs Nbr myID 328328038 9053 1 15 382617193 1201...

I am a novice when it comes to SQL and Access. I am trying to add several Columns to a Table that Exists using ALTER Table. Can I do this in one statement or do I need to use a different ALTER TABLE statement for each column. If this is able to be performed in one statement what is the syntax...

Access changing syntax I have the following query SELECT [s004 - Fee Schedule most used].* INTO [Fee Schedule unique] FROM [s004 - Fee Schedule most used] INNER JOIN (Select [myid], MAX(MaxofIPA1) as MAXIPA from [s004 - Fee Schedule most used] Group by [myid]) AS M ON [s004 - Fee Schedule...

I am a novice when it comes to Access SQL – I have the following Make table query. The query as written provides the results I need (not sure exactly how) but I now need to add a primary key to table (autonumber) How would I do this and what would the code look like? Any help is appreciated...

I would like to update a table with information from other tables. I need know how to update the factor column with the information that is contained in different columns in the Rate table (see updated claim table for example). I can look up the column I need to access in the Procedure table...

Account Reconciliation Query I am trying to create clearing logic for a table. Unfortunately, I am a very new user to Access. I have downloaded the account information from our computer system to perform account reconciliation. I would like to remove offsetting entries from the table to...