INSERT INTO code not working properly.

[Alphix]

I am not able to fix my INSERT INTO Code to input my data into my table.

The times seem to enter properly but the results and the text does not enter at all.

Before clicking the insert into button:

Event2 = Machine Fault
Event3 = No Parts
Event4 = Bathroom Break


Event5 = Lunch
Event6 = Meeting
Event7 = End of Shift

Please Help.... Error 128 fail pops up.
INSERT INTO SAMPLE.zip

Thanks




Also, I tried to use F8 to debug and step line by line. (This seems to not work).

[ranman256]

Dont use SQL code. Use a query.
Are you using a query?

[Alphix]

I would like to input the initial data into a table.
This is replacing a paper document in which several hundreds of employees are using.

After the initial data is collected then I will use dynamic queries for the various users.

Is it possible to enter this data into a table?

[ranman256]

Tables are where you store the data.
Queries add , subtract , modify data. They are the VERBs of a database.
Use an append query to add data.

[Alphix]

Now I am really stumped....I am still an infant in creating a database. I hear what you are saying but I am do not have any ideas on how to approach it that way.

How can data from different users at different areas and different events be pulled out if I only have time stamps in my tables?

at the very end of my project I would like to do queries on for example:

(1) How machines failed for a particular event?
(2) What was the down time for Machine A on January 2014?
(3) I would like to have charting capability.

That is the reason I thought to collect all my data in a table first.

Now it seems like I am back to square 1 on how to collect the data.

I need some help....

[Alphix]

Do you think if I should categorize the data into different tables then at that point I can create query relationships?

[June7]

Elapsed time and total elapsed time should be calculated in a query, not stored in table.

Summing these 7 elapsed times will require an expression like: Nz(Elapsed1) + ... + Nz(Elapsed7)

There is only 1 table. What relationships do you want to build? The data structure is not normalized. As is can have only 7 start/stop pairs - what if you need 8 or more - what if you seldom need more than 4? A normalized structure would be like:

tblMachines
ID (primary key)
MachineName

tlbUsers
ID (primary key)
LastName
FirstName

tblMachineEvents
MachineID (foreign key)
UserID (foreign key)
DateTimeStart
DateTimeEnd
EventCode

[Alphix]

Thank you for your thoughts on this. I will have to re-think this.

My query will have to calculate up time and down time from machine "A", "B" and "C".
My query will have to let me know all the machines particular users used.
My query will have to chart out efficiencies of machine and users.

Thanks again for everyone's suggestions, I appreciate the help.

[June7]

The down time calc will be more complicated with normalized structure.

Not sure about efficiencies.

Will it be the same user for all 7 Start/Stop?

It is a balancing act between normalization and ease of data entry/output. Maybe you should stick with non-normalized structure, however, still say saving the calculated data should not be necessary.

Keep in mind that tables and queries are limited to 255 fields.