Recent content by ptrifile

Thanks Andy, I am using this in a MS Access query but this helped me get the desired results. Thanks again!

I have a simple query where I am adding today's date in a field and then adding 12:59:59 to the end of the date. My question is, the query is resulting in the following: 8/3/2020 12:59:59 and would like it to be formatted as follows: 08/03/2020 12:59:59 The query I am using is IDate...

Yes, there can and are multiple From1 Values. Since these are emails coming in to an inbox, there can be many received from the same person. I apologize for not putting that in to my example.

No, the primary key in the table is "ID". I can certainly change it as I do not need the ID field.

The table only has the 3 fields, the example I gave was what the query should look like. So, the query is giving me the COUNTOFRECIEVED. So my table only has ID, From1 and Received. The SQL, below, is what you had suggested. UPDATE tblinbox_test SET tblinbox_test.[Count] =...

Hi Duane, thanks again. It's close to what I am looking for, however it is skipping numbers for how many counts there are for a person or countofreceived. it starts with 0, 1, 2, 3, 4 then jumps to 19 because the #4 "person" had a count of 15. Am I doing something wrong? Can't thank you...

Maybe it would help for me to explain what I am doing a little more. Hopefully it will help. I am exporting Outlook email fields into a table in Access. The table only has 3 fields, ID(PK), From1(who an email is from) and Recieved (when an email was recieved)and date/time. My query is simply...

Hi Duane, thanks for jumping in. I believe that since I am grouping on the "From1" field that is what I would use to base the count on. Hope that helps. Thank you, Paul

I am using the following query: SELECT "Outlook" AS queuename, tblinbox_test.from1 AS employee, "3" AS eventType, Count(tblinbox_test.from1) AS CountOffrom1, "SYSTEM_Outlook_VCT" AS updateBy, DateAdd("s",-1,DateValue([received])+1) AS updateDate FROM tblinbox_test GROUP BY "Outlook"...

That worked perfectly! Thank you!

Thanks for the suggestions guys, much appreciated. Duane, I am only looking to show the results as I will be exporting the query to a txt file to upload in to another system. Your solution worked but it shows as "43978.9999", I understand that acutally is the date and time I am looking for but...

Hi, I have a simple query that pulls from 1 table. One of the fields is a date/time field. I need to change the date/time entries to all the same time. Here is what I am trying to accomplish: Date field 5/27/2020 11:29:00 5/27/2020 8:30:00 5/26/2020 15:35:35 Desired results from query...

I have a report where I am summing the count of a field based on another fields criteria. I cam currently using the following successful: =Sum(IIf([released_by]="NAME" ,[countoftrans_NO],0)) This works fine, but I need to add additional criteria to the "released_by". I have tried "Name"...

Combo, thank you for the suggestion, I will give that a try as well. Duane, thank you as well. When I ran the query you provided I am getting multiple instances of an ID number for the same user. I can only assume that is because there can be multiple "end" times as well? Is there a way to...

Andy, that is absolutely correct and what I am looking for. Paul