Re: Viewing all data entered for the week

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Wed, 5 Sep 2007 11:02:03 -0700, Steel Bananana
<SteelBananana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Here's my situation...
I have about 20 pieces of equipment that must be maintained. We do 'weekly
checks' on all of them. I have built a database that has tables for each
piece of equipment, and gives me reports on deficiencies, error messages, and
the like (regardless of date).
However, sometimes we get cought up in work, and one guy will do some checks
on Monday, and another will finish up on Tuesday or Wednesday (or both). I'm
looking to be able to pull up a report with all data entries for the week,
regardless of what day they were entered.
Currently, the date field autopopulates and is hidden from the guys. Is
there a simple way to do this? I considered a second field in each table
that lists the monday of that week or even the week number based on the
'today's date' field, but I don't know how to do it!
Any help would be great. I am at the 'beginner' level...shocked I've made
it this far!

Thanks in advance,
Kim


MAybe just:

SELECT * FROM VehicleMaintenance WHERE DatePart("ww",service_date) =
datepart("ww",Date())-1

This should give you all vehicles serviced last week. Try it and see,
but use your real table and date column names.
.

Relevant Pages

  • Page number always 0
    ... I am using access 97 and for some reason on my reports the page number always ... regardless of what page it is on. ... happens in every report in this one particular database. ...
    (microsoft.public.access.reports)
  • Re: Need help with a query
    ... My database has a few fields: ... the first is the ID field increments by one for each new field ... What i'm trying to do is, if i have a piece of equipment which i have to ... Query in Access 2003. ...
    (microsoft.public.access.gettingstarted)
  • Subform comments not staying in order
    ... I am running a database in Access 2003. ... It catalogues equipment information ... This form has a subform at the bottom which draws directly from a Comments ... The Database has always sorted by date ascending somehow, ...
    (microsoft.public.access.forms)
  • Re: Thoughts on astro imaging
    ... Martin R. Howell wrote: ... Regardless of what the naysayers will tell you. ... personally I find images taken with them less than pleasing and I would prefer a dedicated Astro CCD Camera. ... But a point that was made in this discussion about the cost of the equipment used in published photos in S&T is off..... ...
    (sci.astro.amateur)
  • Lookup field from linked tables - can it be done?
    ... in my Access 2003 database I now have 4 key skills tables; ... tblEQUIPMENT - listing equipment iinformation ... I also have two linked tables from a current Training Database; ... tables Employees and Courses, ...
    (microsoft.public.access.tablesdbdesign)