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 Rhinorhino 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: jchollo
  • Content: Threads
  • Order by date
  1. jchollo

    Queries

    Hello, If I have a query which produced the following: Org: Status: Count of Status: Q488 Student 8 Q4883 New Hire 10 Q4884 Student 2 Q4886 New Hire 5 The Org field and Status field are Group By in the total line and used...
  2. jchollo

    Data Access Pages

    I generated a data access page but when viewed in the browser, I cannot type in or edit any of the fields. Is there something else I need to do to the page? What I want to do is have a page on the Internet which I generated the page from a table to have people to be able to input data on the...
  3. jchollo

    Query Question

    I have a table with a field called Status of Action which has the choices to choose Active, Completed, Closed. Once an item is closed, how do I go about placing this entry in a closed table. Do I have to set up another table named Closed. How would I write the code to put an entry once...
  4. jchollo

    Still Trying to Query Overdue Dates

    When I entered the query below - I received the error - "You may have entered an invalid identifier or typed parentheses following the null constant criteria." The string: Overdue: IIf([Due Date]<Date(), Int(Date()-[Due Date]) & ' days past due', '') I do type this string for the criteria in...
  5. jchollo

    Query Overdue Dates

    I had asked this question previously and was told to use the DateDiff() function. I have an action database with a field Due Dates. I named another field Overdue which is currently blank with I want to use for the query results. I want to figure out once a due date is past, have the results...
  6. jchollo

    How to Query Overdue Dates

    I have an action database with a field Due Dates. I named another field Overdue which is currently blank. I want to figure out one a due date is past, annotate in the Overdue field - 1 day past due, 2 days past due, etc. in red. How would I configure this query? tks

Part and Inventory Search

Back
Top