Search results

sorry need more basic advice :( example ?

I am creating a maintenance database, break downs are raised, engineers select a job. They can log off the job so i can capture times etc. However Im now working on capturing the close date which is the time the break down was fixed . I have a field in a table called "CloseDateTime" and...

Ive been playing with your example for saving a link into a field in access. Your example asks for a location and then select the file. However I think my need is much simpler. I am creating a audit database, The auditor will scan and save the audit in a specific location. They will complete...

I have a ODBC database which collects production data randomly during the day. I have a date/time field and a parts made field. I need to identify the total parts made each hour. Is there a way I can create a query which will sum all parts made by hour.

sorted in Critera - Between #06:00:00# And #18:00:00#

I have a query giving me a list of times, I want a query to only show values after a specific time. I have no control over the table, it saves a date/time value. Ive created a query and stripped out the time using the TimeValue command. I assumed in the criteria I could simply put >06:00:00...

I am connecting to a ODBC databaste table containing a date and time field, I want to strip out the date only. I created a query and used the DateValue function, run query, great i get a list of data with dates only, Great. However when i then put a specific date in the criteria say 10/3/18...

lol - Ive done this lot no joy The date criteria is Between XXXXX And XXXX it stll shows the total parts for each machine every day. However I have a solution... Create query with Date field which collects all the records between the dates required. Create a second query using the 1st query but...

Nope - Not that straight forward lol , I need totals across a date range your solution simply totals the parts made each day. My query could span days, weeks, months ect. I simply want the total across each machine, thus if I have 3 machine numbered 1,2,3 and we mad 100 parts per day and my...

Simple Terms Table with three fields: "MC" "Date" "Parts Made" My query selects a date range I want the query to give the "total parts made" on each machine between the two dates specified. I don't want it to show every record for each machine, just the total parts made for each...

Thankyou - great

Im running a query to some me total parts made between 2 dates. The dates are selected from a form with the query looking to this form to selected the date range. When I run the query it shows me total parts made for each day. What i would like is a single total of parts between the range...

reply, will do I just need to extract the relivant detail and remove stuff u dont need Cheers

I am close "I Think" however:( Open Mainform +Subform Add Production data (Date, Machine, Good Parts, Bad Parts..........) Subform section add (subform linked by Machine) add d/time catagory, mins EG: 800 good parts & 12 bad parts made on M/C 1, there were 2 down time issues, A-12m & B-10mins...

PK & FK - ? KEY FIELD ? Really appriciate your advice, will have a play again tomorrow

More info I have linked the subform to my main form by the Machine Number. However when I create a 2nd record for the same machine the subform displays all other downtime related to this machine, is there a way to start with a blank subform every record. Hope this makes sence

Yes you are right had another go, my initial issue was the setting of a key field, this is now corrected. However Im getting other issues. Im using a Subform to enter the downtime data (main form production detail) however the subform shows data from previous entrys, I have Data Entry set to On

Scope - Capture down time by machine We have production machine producing parts over a shift Within this time there will be down time. The operator records the down time and production data within a database. The structure is basicly Date Shift Machine No of Good Parts Made No of Bad DT1...

HA - Nice - I actually did a very simular thing yesterday and its a solution. I created a copy of my printed label, blanked out the 2 unwanted numbers. WIN WIN, customer gets what they want and we maintain our 5 digit tracability number. Thanks too all, I would have liked a more technical...

Still desperate for some help