Weekly repairs sent

Trilback

Registered User.
Local time
Today, 14:57
Joined
Nov 29, 2013
Messages
88
I have a daabase that I currenty have that I keep track of the warranty repairs, aka this laptop has a broken LCD screen or this desktop has a bad hard drive. What happens is on a weekly bases my boss needs a count of what warranty repairs I need to richmond for repair that get counted like every Wednesday. I am trying to think of a way to keep track each time I send a bunch to Richmond that the count resets so that say I do 5 computers is count from the begning after the last count was done if that makes sense.
 
When do you need this? You say weekly, then you make it sound like on-demand.

What you would do is build a query to show the data you need, then depending on the timeframe you would set the criteria in the criteria area underneath the appropriate date field in the query.

If its every wednesday (or friday or specific day of the week) you could code the criteria to determine that. If its since the last report, then you would need a new table to hold when the last report was run so that you could reference that date and use it in the criteria.

Which is it?
 
What you would do is build a query to show the data you need, then depending on the timeframe you would set the criteria in the criteria area underneath the appropriate date field in the query.

If its every wednesday (or friday or specific day of the week) you could code the criteria to determine that. If its since the last report, then you would need a new table to hold when the last report was run so that you could reference that date and use it in the criteria.
That above sounds like a great idea. I think I will go with that.
 
Still trying to wrap my head around how I would code this to work. I can start with today's date as a starting point.
 
So you want to see what is scheduled from today to (example) a week from today?

Code:
WHERE [RepairScheduledDate] Between Date() And Date()+7;
 
So you want to see what is scheduled from today to (example) a week from today?

Code:
WHERE [RepairScheduledDate] Between Date() And Date()+7;

normal its from Wednesday to Wednesday but sometimes of the holiday's as we work off the Goverment schedule its not Wednesday to Wednesday, It might be Wednesday to Thursday but normally just Wednesday to Wednesday.
 
How about posting a jpg of your tables and relationships?
 
You can make it more flexible by having an unbound search form with two fields on it: From: & To: From:'s 'default' value can be Date() and To: can be Date()+7, but the user can change it if needed.
 
You can make it more flexible by having an unbound search form with two fields on it: From: & To: From:'s 'default' value can be Date() and To: can be Date()+7, but the user can change it if needed.

The end result is I want to have a list of models from Date() and Date()+7 of the warranties that I have done. Like for example.

from 1/8/14 to 1/15/14 I did 5 8000 desktop's and 1 8460 laptop. The reason I need to know this is that they get send for repair so my boss needs to take it out of our inventory, so if I can have it calcuate from Date() and Date()+7 then I can create a report or some sort to say 5 8000 desktop and 1 8460 laptop left our building. If that makes sence.
 
I get it now, have maybe a table that today date as a starting point. and when next week's repairs get counted start from that date is which is was counted and so forth.
 
Why would you make a table with today's date? Date() will return (today) every time. Now() will do it with a timestamp as well, if you want.

I think I'm missing something in your process. A query should do for your needs, comparing Date() to your DateField (DateShipped? DateCompleted? You know your process better than me...)
 
Why would you make a table with today's date? Date() will return (today) every time. Now() will do it with a timestamp as well, if you want.

I think I'm missing something in your process. A query should do for your needs, comparing Date() to your DateField (DateShipped? DateCompleted? You know your process better than me...)

Let me try this again. Say TODAY I sent 5 8200 model desktops and 1 8460 laptop for repair. Then on 1/15/14 I sent 4 8000's 2 8200's desktops and 3 8460 Laptop's then on 1/22/14 I only sent 1 8460 laptop. How would it reset the count from today to 1/15/14 to 1/22/14 based on my warranties.
 
Is it a warranty repair if you do it within 7 days of... what? DatePurchased?
 
Wow, 4 days and 10 posts later you're still stuck right exactly where I tried to lead you out of.

You need to decide--(1) will this run on a set schedule (i.e. every Wednesday) and this report shows all data from Thursday through Wednesday or (2) do you want to set this to run on demand and store when the last time the report was run and use that saved date as the criteria.

1 or 2?
 
After talking with my co-worker about it and how we do this on a diaily bases. It best I just hand count it instead. Thanks for all the input.
 

Users who are viewing this thread

Back
Top Bottom