Search results

Testing data in batches, entering in table directly or create a "pseudo" table? I know entering info into the table directly is a no-no, but that is what I want to do: we do testing and are currently using a excel sheet. We test 6 to 12 units at a time. all the units are run through each test...

Hi, I've been asked to find repair history in my access DB for any unit made in the past 10 years with a specific output range from an excel sheet and see if they have come back for repair in my access db. I have linked the excel sheet to acces and have a query to generate a list of serial...

I have a query set up below which when launched, a pop up field appears to type in the serial number and returns all the repair entries containing that serial number. I want it to be able to return any serial numbers that contain a partial string in the pop up field ei: type "13" in the pop up...

Hi. The Question is "How many times has a [Serial #] been repaired and come back for repair in 0 to 90 days, 91 to 180 days, in a date range". The purpose is to quantify design or process changes impact on longevity. so I have a repair table that has all the info in it. Then a simple Date...

Hi, first I'm marginally access literate but functionally SQL illiterate I have a repair database which include [serialnumber] and [date in]. there may be multiple repairs on a unit so the table has duplicate [serialnumber]s and a different [date in] for each of the [serialnumber]for each time...

build your query and build the form /report the query info dumps into add one unbound fields for a single criteria or two unbound field for a range like a date range to the form or report, name the fields (ex: date1 and date2) change the tab order to start with the unbound field,for a range put...

I have a repairs db that records [serial number] and [date in for repair], and other info. I've been asked to make a report to summarize the number of units [serial number] that come back for repair by time interval between [ship date] and the first [date in for repair]. the [serial number]...

Hi, I have a form and sub forms with a Serial Number field (unbound field, 1st tab order position) that is used as the look up for a query that fills in the form the Serial Number field in "after update" event is set to do a requery macro This is easy and works and fills in the rest of the form...

There has to be a simple way to do this, but I'm not finding it. I've set up a query to print test result sheets in a serial # range. the results are dumped in a form for each serial # when I try and print the range of tests, the forms are wrapped from one print page to the next. I've tried to...

I have a simple query to pull records in a range of serial numbers from a linked excel sheet. Both the access and the excel files are on a shared network server It works until I save it, then I get a numeric overflow error. once I open the query and change anything (and before I save it) it...

I'm building a sum query based a range query. The range query is all the fields I will put in the report and one Criteria on a date field of Between[Start Date]And[End Date]. When I run this query I only get teh Start date and end date popups The sum query is all expressions in the field...

=sum(IIf fields in a date range query for a report I need to build a report on a repair datebase i made the report need to be able to sum the fields in a date range can I do a date range query and sum the entries in the selected fields in the same query? or do I need to do the date range, then...