Recent content by chrisl1471

Don't believe that is the answer....a join will show me only those where the records date (weeks) are EQUAL.....So I could have a record opened in week 11 but closed in week 12 or 51...........If you left or right join it then it would be ALL from one side and ONLY those where the join is...

Alright gurus: Have a question for ya, I have a database that shows orders, I have 2 date fields for REQUESTED ON then another for STATUS Date as the status changes to eventually "CLOSED". What I am trying to get the DB to show me, is on week x I had XXX open records, and keep that total...

Morning all, well for me anyway! So I have a database that I am running a query that gives me the number of records closed by weeks...so I get the # of the week and the count of the closed records.... I have 1 week where no records were closed, so it is a null value, but in my datasheet it...

Great idea, I do not have a use for that with my databases currently as they are not used by managers for things like you suggested....but the concept is solid, and will come in handy for those that do have that need/requirement.

Its pretty simple really, build a new form that is blank....Then go to the property sheet and add "event procedure" and add the above code for the "on timer" under the "event tab", the set your "timer interval" to 1000 ms is what I recommend so it checks for the expired time every second. Next I...

This works but does not return the most recent 5, as I thought it wouldn't....The result goes back to 2014 which is not what I am looking for....I am looking for the LAST (most recent) 5 aircraft that completed the input areagroup

arnelgp: CORRECT!

Many tv/ship As in the attachment 2AF:0028 is ALL 1 single TV/SHIP You have a 1 to Many relationship 1 areagroup per TV/SHIP each areagroup & TV/Ship combination has 1 "complete" date

Hello all, I am in need of some help building what I believe is a complex query for a DB I am building. I have a list of "TV/SHIP" being built in a plant, these "items" go through various "AreaGroups" on various dates "complete". All of this data exists in a single table within the DB. What I...

Thanks, DOC man that is what I thought it might be, just couldn't put it in words.

Hello all, I have been building databases for a few years now, started after a fellow employee that has written most of our companies DB left....Tag your it! Anywho.....I have always been told that when building a multi-user network (split) DB that it is wise to build in a auto timeout (Idle...