Search results

LOL IIf([Our repair guys keep watching the coffee pot brew coffee so they can have 1 fresh cup] Between [8:00AM] And [5:00PM], [your code],0)) :eek::D

The question I am answering is "how many times have we performed a repair(on any unit) and the unit has come back for repair in 0-90 days, 90-180 days, etc"

any form you make in acces can be used to imput data back into the tables. you need to link the individual field to the table column you want the info to go into. Maybe the thing your missing it the primary key assignment to a field that is unique to each record? access can generate primary key...

you are ASSUME'ing I'm wanting to do arithmetic with the numbers I am generating ;) There is a date out in the db which is not relevant nor is the exclusivity/inclusivity of the date difference range. I will be summarizing the instances of time periods between [Date in]'s as in a second query...

my work internet connection is flakey and not finding any .co.uk sites so I'm typing this at home during lunch, removing the "outer" alias statement worked, I think the "outer" alisa statement was for selecting a field based off the date where I'm only interested in the date, so that statement...

so I think I need to dich the outer alias statment as it refers the field to itself (maybe returning one record?). I'm not at work (db) but does this look right? SELECT [XRS-3 repair].[Serial #], [XRS-3 repair].[Date in],(SELECT Max([Date in]) FROM [XRS-3 repair] AS Alias WHERE Alias.[Date...

so I looked at that and wrote this SELECT [XRS-3 repair].[Serial #], [XRS-3 repair].[Date in], (SELECT [Date in] FROM [XRS-3 repair] AS Alias WHERE [Date in]= (SELECT Max([Date in]) FROM [XRS-3 repair] AS Alias2 WHERE Alias2.[Date in] < [XRS-3 repair].[Date in] AND Alias2.[Serial #] = [XRS-3...

yah, I think I need to group by [Serial #] ascending order on the [Date in] then for each group have some sort of macro that select the earliest [Date in] and the next [Date in] in the [Serial #] group to generate a DateDiff Then a loop to select the previously selected next [Date in] and the...

thanks, I did fumble around and right clicked and found the SQL View :) looks like the code is returning DateDiff between the first [Date in] and last [Date in] for each [Serial #], not DateDiff Between [Date in] 1 and [Date in] 2, [Date in] 2 and [Date in] 3 Here is the code SELECT...

thanks! it appears more simple than I suspected, one last Q; Where do I put it? :o Field, Total, Sort, Criteria??? someplace else?

sorry for the confusion, I'm not literate enough in SQL/VBA to even form the question properly

what is meant by inclusive and exclusive dates? I think "taking the next datin as the previous date out" is what I want to do until there are no more dates, for each record with the same serial number.

uhm shure?

above is what I'm looking for except not adding the datediff. also I'm not interested in one repair date entries (the repair was correct) does this help? Serial number Datein DateDiff 111 1/1/13 111 2/11/13 40 111 2/11/14 365 116...

once I get a column of differences between dates I plan on using sum(IIf statements to categorize the results into 0-90 days, 90-180, 180-365, 365-730, and 730+ days.

this is the part I need help understanding ;) and how to "loop" through the dates where the differences between "a and b", "b and c", are calculated but not "a and c"

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

my limited understanding is any query associated with a form or sub forms runs before the form opens. so you open the form, no criteria is available, and the query return zero results. so you need to run the query again after the criteria is entered or there is a prebuilt macro called...

so I have the two queries working now, easy peasy, enable Totals so the Total row apears in the query design view query1 for the repair table: [Serial #] Total: Group by [Date in] Total: Min Query2 for linking the date sold and repair date select the sales excel table with the sn and ship...

read the post I just made on this board "(2007) easiest way to include query criteria in a query form"