G
GMan
This is a logical question I need answered to help develop a query... We
clean things brought into our facility... we want to know what jobs were not
completed last year on a given date... - currently we have 2 fields that we
thought would do the job but either were not looking at this correctly or
our logic is flawed... We track the date the item "date came in" and the
date the item was "date completed".... its easy enough to get which jobs are
currently incomplete - we just extract blank records for "date completed"
field - once the job is completed we fill in the field with the date it was
completed ... depending on the job some items get cleaned in 2 days - while
others may get cleaned in 6 months...OK - so what logic or method can we use
to determine that on June 15th of last year - how many jobs were in house
and still incomplete? How can we pit these 2 fields to get this info...or is
some other field of info needed to extract this.
Hope this makes sense and someone can help
clean things brought into our facility... we want to know what jobs were not
completed last year on a given date... - currently we have 2 fields that we
thought would do the job but either were not looking at this correctly or
our logic is flawed... We track the date the item "date came in" and the
date the item was "date completed".... its easy enough to get which jobs are
currently incomplete - we just extract blank records for "date completed"
field - once the job is completed we fill in the field with the date it was
completed ... depending on the job some items get cleaned in 2 days - while
others may get cleaned in 6 months...OK - so what logic or method can we use
to determine that on June 15th of last year - how many jobs were in house
and still incomplete? How can we pit these 2 fields to get this info...or is
some other field of info needed to extract this.
Hope this makes sense and someone can help