Search results for query: *

Trying using Select Distinct. I usually go into the SQL view and type Distinct after Select.

I am still receiving the same results SELECT Test.WMHS_INIT_RTE_DTM AS DTS, DateValue([WMHS_INIT_RTE_DTM]) AS DTSCDATE FROM Test; 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 DTSCDATE #Error #Error #Error #Error I have tried rebooting...

Thank you for your reply; but when I add the code I still get the #Error Code: SELECT Test.WMHS_INIT_RTE_DTM AS DTS, INT([WMHS_INIT_RTE_DTM]) AS DTSCDATE FROM Test; 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 DTSCDATE #Error #Error...

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 tried it on my first query and it seems to work! :)

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

Thanks - I will give it a try - At this point I don't care how slow it is - just as long as it works.. Thanks again

PHV -- How would I choose the record to keep. The problem with this data is that instead of updating the record they added a new record. My select query selects the records I would like to delete.

I received the table with out a primary key, hence the duplicates. The primary key should hve been ID.

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

One more question -- when I go to save the query -- I receive the error message Microsoft Access has encountered a problem and needs to close. We are sorry for the inconveience. I have compacted and reparied the database several time -- I also created a new database an imported all my table...

Thank you so much -- It worked like a charm!!!

It does not matter how I do it -- its just I found an example on the forum that returned the results that I needed (when using the Max StatusUpdateID). I was trying to modify it to order by date and order. I am a novice, so I am limited in my knowledge. I try to use the forum to model my...

Thank you for your quick response Initially that is what I tried however if a person forgets to add a status and later goes back to correct (e.g. entered status for 3/26 and then realized the status for 3/22 was not entered) the latest status is incorrect, which is why I added the order column...

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

OOPS - I posted to the wrong forum - Sorry

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

Thank you so much -- I alway appreciate your help

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

Thank you for your quick respones Again... It worked...Thank you agian for your help....