Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ptrifile
  • Content: Threads
  • Order by date
  1. ptrifile

    Format of Date from Query

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

    Sequential Numbering

    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"...
  3. ptrifile

    Change Date/Time Field

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

    Sum with multiple criteria

    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"...
  5. ptrifile

    Suggestion for Calculating data

    I have a spreadsheet that holds 4 fields. date, time, action and ID#. I will do my best to try and explain my need. I am willing to do this in excel with VBA or in access as well, just not sure the best approach. I am trying to get the total time elapsed for each ID# entry. Each ID# entry...
  6. ptrifile

    Outlook E-mail to Excel

    I receive emails daily that contain copied spreadsheets from Excel into the body of the email. I would like to be able to select multiple emails and send the "spreadsheet(s)" to one excel file. Essentially taking multiple emails (body) into one excel file. I have found some VBA code that...
  7. ptrifile

    Calculating number of people working per hour

    I am attempting to make a formula to calculate the total number of people scheduled per hour based on their start and end times. It seems to work fine until there is a shift that crosses over midnight. I have attached a quick sample of what i am seeing with my formulas and wondering if someone...
  8. ptrifile

    Concatenate time

    I have 2 cells that contain times. one has, for example, 1:00 pm and one has 8:00 pm. I am trying to concatenate them into one cell looking like this 1:00 pm - 8:00pm. I cannot seem to get this to give the desired results. Any help is appreciated.
  9. ptrifile

    Query for time intervals

    I have a table that holds the fields [type], [DayOfWeek] and [interval]. I have a query that groups on each of those fields. This all works fine but sometimes there is no data in the table for a particular 15 minute interval, there was just no order for that particular time period. What I...
  10. ptrifile

    Change hyperlink

    Lets say I have rows that show numbers 1-10. So in A1 it would be 1, cell A2 would be 2, Cell A3 would be 3 etc..etc. What I would like to do is be able to click on one of the cells and have it take you to a URL. So for example if I clicked on cell A1 it would take me to...
  11. ptrifile

    Contents of Cell

    I am looking to find if a cell contains a 12 digit string of numbers. This cell can and does contain numbers and text, it is used as a "notes" field and I am looking for a formula/VBA that would return a yes or no if anywhere in the cell a string of 12 numbers(a credit card number) appear...
  12. ptrifile

    Query Help

    Let's say I have a table with 2 fields. They are "EmployeeName" and "Manager" name. Now I want to have a query that will show EmployeeName, Manager, and then the Managers Manager name. So i am trying to have 3 levels of who reports to who in one record. Can I do some sort of lookup in the...
  13. ptrifile

    # Business Days

    I have 2 fields that I need to use to calculate a Service Date. The first field is "Created_Date" and the second is "Service_Level_days. The Service level days is the number of business days a item needs to be "closed" in. I need to create a field that shows the following: if the...
  14. ptrifile

    If NULL then N/A

    I have a simple field in a report that I am trying to have show "N/A" if the field is blank. I am currently simply using =Avg([days]) I have tried a few variations but cannot seem to get it right using the =IIF(IsNull...function. Any help is appreciated. Thank you, Paul
  15. ptrifile

    Mark Duplicates

    I have a spreadsheet that I need to identify duplicates and I am successfully using =IF(COUNTIF(C:C,C2)>1,"Duplicate","") to do so. I need to know if it is possible to do the following: I would like the "duplicate" to show for all of the duplicates except for the last entry for each...
  16. ptrifile

    4 tables

    I have 4 tables that are connected by a Customer # field. I only want to show records when the Customer # shows on 2 or more tables in the last 30 days. Can anyone help me get started with this? Thank you for any help or suggestions.
  17. ptrifile

    Show data within 2 days of each other

    I have a simple report that displays date,type and origin. Is it possibly to show only those records that are duplicated by origin and type within X amount of days of each other? Any help or suggestions are appreciated. Thank you! Paul
  18. ptrifile

    Maximum and Minimum times

    I have a table called tblLoginLogout that has 4 fields. Date, Name, Logintime, and Logouttime. The data looks like this: date name Logintime logouttime 2/8/2016 Joe blow 8:00 am 9:02 pm 2/8/2016 Joe blow 9:04 am 10:02 am 2/8/2016 Joe blow 10:03 am...
  19. ptrifile

    Simple Report

    I am trying to create a simple report with 2 tables. tblEmpInfo and tblsurvey. They are joined with employeename. If the persons name is in tblEmpInfo and not tblsurvey the person is not shown. I would like to be able to show all employee names with a 0 (zero) next to the names that do not...
  20. ptrifile

    Delete Query Help

    Looking for some help. I have a delete query that does not appear to be working. I have two tables (tblCurrentTimeOff and tblEmployee). When the query runs, if tblCurrentTimeOff.EmployeeNumber matches an EmployeeNumber in tblemployee I would like to delete that record in tblEmployee. I...

Part and Inventory Search

Back
Top