Search results

I have a table being populated via various forms etc, I am capturing dates and times via VB depending on various states. My issue, 2 fields is being populated in the wrong formats as in mm,dd,yyyy (American) when I need it in English Format dd,mm,yyyy. My colleague worked on the code , he...

Can you help , I have 2 drop down boxes , the Ancillary dropdown filed are dependent on the value chosen in Machine ID. I have a query that looks at the value in Machine ID and provides a list of Ancillaries related to this choice. The query work fine as in I chose a machine , run the query...

I have a couple of tables - one contains work requests and one contains the engineering data. I use various query's for the engineer to select the job . Via a form based on a query. When the engineer select the job I want to set a Yes/No field in the Works Order table to "true". I need...

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

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.

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

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

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

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

I have a database used for producing labels on product. there is a unique 5 diget code we use for our tracibility, however one customer demands a 3 diget max 1 to 999 Thus i would like to create a field which auto fills a number 1st record = 1 2nd record = 2 3rd record = 3 ect...

Before you all shot at me I seem unable to post int the correct sectiction My simple problem, I want to run a qery to select the last record in a table ie i have a qery created from 3 tables The qery gets the last record entered from a specific table the specific table does have a date...

I have created a drop down box for my customer field the combo box has multiple collums. I have a second field which fills in the address dependant on the customer selected using the following =[Cust_cmbo].[Column](1) This workes fine the address field fills with the correct data . Here...

Simple help please Im trying to get this to work but not very well, I have a table with values in and a second table i wish to create records via a form. I want to auto fill some of the fields and understand the Dlookup function is probably the best way to go. I have looked up the examples...

Please help. Ive created a form and added a unbound combo box using the wizard. the combo box looks up values from a field in a existing table. (I told the wizard to remember the value for later use). Ive added a button to then run the report generated from the query. the query uses the...