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