Search results

  1. V

    Query to return records within dates and all names

    I am trying to build a report based off of a query for weekly attendance. My query as of now uses the Between [Start Date] and [End Date] for it's criteria. The problem I am having is that everyone will not have an entry every week but I will need everyones name returned in the report. How would...
  2. V

    Output HTML to access page

    I need some help with this code. As of now when I have people take a test, the code spits out the missed questions with the correct answers as well ass you score to the file C:\test.htm. It works fine on windows 2000 where we can still write to the C:\ drive but I need it to work on XP too. So i...
  3. V

    Input field data from last created recorded

    How would I automatically fill in a field on a form with the data from the last created record from another table? example: TicketInfoForm IDnumber=001 > TicketOutageForm InfoIDnumber=001 TicketInfoForm IDnumber=002 > TicketOutageForm InfoIDnumber=002...
  4. V

    query only if failed to meet requirements

    I am tyring to set up a query, that runs from a selected date range, to return only the records that don't meet the requirments. For example, I have four fields: Name Date Attended Required I want to start the query from a date range usesing Between [StartDate] And [EndDate]. There are...
  5. V

    design advice for training session tracking

    I've been tasked to create an application that can track weekly training sessions for over 300 personnel. I'm not sure how to set up the tables to get the desired results. I will need to be able to pull weekly reports based from date query, including the number of sessions attended and what...
  6. V

    skip missing dates...is it possible?

    i have a report that opens from a query that pulls from 8 different tables using the date as the primary key for each table. I want to be able to open my query without having to input a blank record for each date in each table. Basically I don't use every table everyday. Sometimes I just use 3-4...
  7. V

    Subreport date prompt

    I have 6 reports that i want to place in a sinlge report. Each of the reports source is a query from a date range. When place thw 6 subrepoert in one report I get a prompt for the start and end date 6 times (i'm using the Between[start date] and [end date] criteria in the query. I would like a...
  8. V

    Adding 3 fields to mkae 4th?

    I am trying to take a form that has 4 text boxes and add the first three together and have the sum show up in the 4th box. Is this possible? Textbox1 + Textbox2 + Textbox3 = Textbox4 I am tryimg yo add up total support hours for my network shop. thanks for any help.
Back
Top Bottom