Recent content by surfbum3000

Thanks Golom for the lead. This code worked: SELECT tblTestDups.CASE_NUM, tblTestDups.STARTTIME, Concatenate("SELECT STARTTIME FROM tblTestDups WHERE CASE_NUM =""" & [CASE_NUM] & """") AS STARTTIME2 FROM tblTestDups;

I have been searching the FAQs and have googled it. As with most searches such as this, I am not sure what topics to search on. I have read about append queries but that doesn't seem to work. I have also come across concatenate but that also doesn't seem to do what I need done. I don't mind...

I need to merge two fields only when there is a duplicate. I created a query to separate the duplicates from a table (although that step may not be necessary. The table contains appt. information for an outpatient clinic. Some patients have multiple appts. A sample of the data is as follows...

In my table tbl2DaysAppts I would like to only view the records where the date and 2 names are equal. The query below does not provide this information. Any assistance is appreciated. SELECT tbl2DaysAppts.tblAnasaziStaff_LAST_NAME, tbl2DaysAppts.STARTDATE FROM tbl2DaysAppts WHERE...

Thank you very much for your help. No wonder it wasn't working! I changed the field name in the table from Date to DateUpdated. I then inserted this code in the expression builder On Dirty. Sometimes it's the little things. Private Sub Form_Dirty(Cancel As Integer) Me!DateUpdated = Date End Sub

I have read access help and Tek Tips http://www.tek-tips.com/viewthread.cfm?qid=1226608 attempting to find a solution. I have a table named tblMasterList with a date field, format Short Date. None of the existing records have the date field completed. I also have a form titled frmMasterList...

Thanks.

I have a table that needs multiple column data types changed to text. I am using this code that works: ALTER TABLE tbl6DaysSERVICES ALTER ID text The downside is I have to create a seperate query for each column to change each data type. I have tried: ALTER TABLE tbl6DaysSERVICES ALTER ID...

I created a macro with the following parameters: Transfer Type: Link Database Type: Microsoft Access Database Name: C:\LOGS\092006CALLS.MDB Object Type: Table Source: LoggedCalls Destination: LoggedCalls Structure Only: No I run the macro using Scheduled Tasks on the first day of each month...

I called Microsoft and paid the $35 fee for assistance. Turns out PHV was right and the problem was the fact the data in the appointments table was not inclusive. When I originally posted, I did not know the software allowed closed cases to be scheduled; therefore, not all appointments were...

This is the code that worked: SELECT tbl4Sites.Start_Time, tbl4Sites.End_Time, DateDiff("n",[Start_Time],[End_Time])=60 AS Expr1 FROM tbl4Sites ORDER BY tbl4Sites.Start_Time; The results in the Expr1 field is either a 0 or -1, with -1 equaling 1 hour.

The time format is HH:MM.

My tbl4Sites has various StarTimes and EndTimes. I only want to see data where the StartTime and EndTime equals one hour. Both fields are text.

Very good. Worked like a charm. Thanks.

Data type = text Your assumption is correct. If any field has :59 I need to add 1 minute.