Recent content by jefflab1

  1. J

    How would you setup these tables?

    Thanks for all your help: 1. I was able to create the 2 tables as stated. 2. It will not allow me to create a relationship one to many. 3. I tried to attach a WORD document with pictures of what has been created and the data entry form but it wont let me. Is their a way I could send...
  2. J

    How would you setup these tables?

    Thank you so much for your reply's guys! From what I take I should create them as follows: Table 1: Circuit Date and Time Field 1: Auto Number (Primary Key) Field 2: Circuit Date and Time Format Table 2-21: Field 1: Auto Number (Primary Key) Field 2: Circuit Date and Time Field 3: Circuit...
  3. J

    How would you setup these tables?

    Brief Description: Fire Dispatch Center personal have to keep record of a 100 Milliamp Circuit System. Its a power system that operates on a circuit from our building to buildings within our city to power their alarm system box. Guidelines: 1. We have 21 Circuits that we monitor. 2. All...
  4. J

    Parameter: Date and Time Question

    So on the report, within the Report Header or the Page Header? And create 2 text boxes? What info goes in which unbound box? Jeff
  5. J

    Parameter: Date and Time Question

    I could try that, that wouldn't be a problem. Could you help me out and explain how I can do that? Thanks!
  6. J

    Parameter: Date and Time Question

    I was going to share a photo of what it now comes up as, but it won't let me. So here is what I did. I followed that link and used those parameters. It works now, but I need some fine tuning. When I run it the first box asks for the following: Between [Enter the Start Date:] and [Enter...
  7. J

    Parameter: Date and Time Question

    I want the person running a report to be asked to input the start date and time and the end date at time. I know I can set a parameter within the query and place it in the Criteria box. I have tried the following, but it keeps on asking for the same input a second time: Between [Startdate...
Back
Top Bottom