Jeff
As Stewart pointed out, just subtract another 7 days for the beginning of the previous week.
We all start at the beginning. I always tell people there are no stupid questions when you are a beginner.
However, when you receive an answer, stop and try to analyze it. Do not blindly copy it. Figure it out. If you do, your knowledge will grow faster.
Why does "start_of_w eek = date()-weekday(date()) +1"...
manxman777
Last Activity: Aug 19 '10, 04:32 PM
Joined: Jun 28 '10
Location: Toronto, Ontario, Canada
-
to get you started, if Sunday is the first day of the week, here are formulae that can be used in queries or VBA or even as Default values in a form's text boxes, etc.
start of week = date()-weekday(date()) +1
end of week = date()-weekday(date()) +7
date() = today's date
weekday(date()) = the day of the week of todayLeave a comment:
-
you can also (if using VBA to determine the form's recordset) use this style
forms!formA!Req uestID (assumes there is a textbox or similar on FormA that is called RequestID)Leave a comment:
-
Dresse:
If I follow this manually, starting with the requirement that JoinID=2 .....
That means that the ReportID will be 2
That means that the Machines in use are 1 and 2
and
The Tools in use are 1 and 3.
Now, the database has no way of knowing which tool goes with which machine, so it mixes them in all possible ways.
Machine 1 with tools 1 and 3; Machine 2 also with tools...Leave a comment:
-
could you post the few records from each table that lead to the results that you are getting?Leave a comment:
-
you need a compound query
the easiest is to save your count query (don't use spaces in field names like DistinctCities) as a separate query called CityCount (or similar)
SELECT customer_name, COUNT(city) as "DistinctCities "
FROM customers
GROUP BY customer_name;
then create another query like this
SELECT customers.*, CityCount.Disti nctCities from customers INNER JOIN CityCount...Leave a comment:
No activity results to display
Leave a comment: