I'm stumped on this one.
I have a report that shows production calculations for a user-selected
period divided up into weeks. Currently, I just use
format([MyField],"ww") to get the calendar week for the purposes of
grouping the data. However, my users would rather that I display the
number of the week in the period they've selected. If, for instance,
they select 2/1/2006 to 2/28/2006, they want to see "Week 1," "Week 2,"
"Week 3," etc. rather than the actual calendar weeks of 5, 6, 7, and 8.
Hope that makes sense.
Any ideas how I'd go about doing this? Thanks in advance for any
suggestions.
-Josh Nikle 2 1791
<jn****@gmail.c om> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com... I'm stumped on this one.
I have a report that shows production calculations for a user-selected period divided up into weeks. Currently, I just use format([MyField],"ww") to get the calendar week for the purposes of grouping the data. However, my users would rather that I display the number of the week in the period they've selected. If, for instance, they select 2/1/2006 to 2/28/2006, they want to see "Week 1," "Week 2," "Week 3," etc. rather than the actual calendar weeks of 5, 6, 7, and 8. Hope that makes sense.
Any ideas how I'd go about doing this? Thanks in advance for any suggestions.
-Josh Nikle
If you set a variable equal to the first date (dt1 = #2/1/2006#)
then use
Format([MyField],"ww") - Format(dt1,"ww" ) + 1
Hope That Helps,
Fred Zuckerman
On 17 Feb 2006 08:12:42 -0800, jn****@gmail.co m wrote: I'm stumped on this one.
I have a report that shows production calculations for a user-selected period divided up into weeks. Currently, I just use format([MyField],"ww") to get the calendar week for the purposes of grouping the data. However, my users would rather that I display the number of the week in the period they've selected. If, for instance, they select 2/1/2006 to 2/28/2006, they want to see "Week 1," "Week 2," "Week 3," etc. rather than the actual calendar weeks of 5, 6, 7, and 8. Hope that makes sense.
Any ideas how I'd go about doing this? Thanks in advance for any suggestions.
-Josh Nikle
"Week " & Format([MyField],"ww")
Wayne Gillespie
Gosford NSW Australia This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Russ |
last post by:
I've got a report that puts dates at the top of columns and the user
is prompted to enter a beginning date when the report is opened. That
date is put in a textbox in the first column like this:
=DateValue()
Then the next columns are textboxes that add 7 to the previous column
for the date display of the next week like this:
=+7
|
by: David Olsen |
last post by:
Would any of you kind souls now how to put into an unbound text box
the week commencing date for the current week which you are in, so
that the report heading would say something like for example, orders
registered to date this "week commencing"--then the text box.Using
Monday as the first day of the week.
Many Thanks
David
|
by: Peter Bailey |
last post by:
I have a query that returns , and :
12/05/04 3 Wednesday
13/05/04 0 Thursday
and so on
what I would like to do now is count the number of bookings by week so from
monday to friday from the first date get the sum of bookings.
|
by: John |
last post by:
Hi
I have a report which lists staff hours for various dates. What could be a
way to assign to each entry the week of the month that the date for the
entry belongs to?
Thanks
Regards
|
by: ChadDiesel |
last post by:
Hello everyone,
I'm having a problem with Access that I need some help with. The short
version is, I want to print a list of parts and part quantities that belong
to a certain part group---One list per page. I created a report that groups
the parts by part classification group with a force new page after each
group. The report is based on a query of that week's orders. Some of these
parts have drawings (usually 2 each stored in an...
| |
by: jnikle |
last post by:
I have a parameter query named "qry_employee_info_reports" that I need
to run in the OnOpen event of a form. I'm after its total number of
records. The query's got several joins in it, and one of them is to
query "qry_last_transition," which is also a parameter query. Both
querys use the same parameter: a control called "txtSecondDate" on a
pop up form.
What I've been trying to do up to this point is to open up this
parameter form,...
|
by: bruce24444 |
last post by:
I have a database which assigns warranty claims to people with a main screen showing number of files assigned to each person. The number assigned shows day, week, month and year numbers so they can be evenly distributed.
The problem I'm having is getting the query to return a number of files for the current date. Week, month and year appear to work fine.
Below are the SQL's for both day and week.
Any suggestions as to what's wrong...
|
by: den4673 |
last post by:
Hello, I am hoping someone can help me and tell me how to correct my
problem.
My report is based on an Invoice query, where each invoice has a date,
amount and corresponding week number. In the report in the detail
footer, I want a summary by week number for Total Invoice Amount and
count of number of Invoices with zero amount. I can get the invoice
total amount, howerver, the count of invoices with zero amount returns
the same amount...
|
by: Christina123 |
last post by:
I don't actually need the code for this...yet. Essentially I need to know if what I want to do can be done.
I have two work books. One is a report the other contains the data that the report is formulated from.
The work book with the data has 21 sheets, one for each day of the week, three shifts a day. This is a planning tool for one of the departments I work for. The planner enters whether the job has been planned, the work order...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |