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.
...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] = DCount("*","[tblinbox_test]","from1<'" & [from1] &...
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"...
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/Duane, when multiple starts and/or ends happen, I require the First or earliest entry for the start time(Evolvenewstart) and the last time for the end time (Evolve - End).
I appreciate the time and help you guys are giving me!
Thank you,
Paul
Hi Andy, thanks for the reply. The result for ID# 456789 should be 6 as I need to use the first or oldest "Evolvenewstart" time not the latest one. I know the nomenclature of the field would seem the other way but i need the first one. I put that in there as an example because my data can...
Hi Duane, thanks for the reply and help! What I am trying to accomplish is only calculate the time that has a start (Evolvenewstart) and also an end(Evolve - End) time. The "Evolvenewstart" is always the start of a process and the "Evolve - End" is always the end of a process.
What is...
I think I should keep this in this thread. With the help of Duane above, I have this currently working in access but now have come across instances where there is a "start" but no "end". I would like to modify the query below to only calculate the time between records that have a start and end...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.