473,411 Members | 2,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > data weekly- monthly

Join Bytes to post your question to a community of 473,411 software developers and data experts.

data weekly- monthly

I have a table with 2 fiels, F1 contain dates and F2 contains numeric.
I have a control on the form and i wand to have the data monthly - weekly
like this,
according with the month of the control on the form:

Day (from F1) Value(from F2)
1st week of month
Mo (31st day previous month) -
Tu (1st day current month) 12
We (2 current month) 3
Th 5
Fr 21
Sa 2
Su 11
second week of month
Mo 26
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11

3th week of month
Mo 15
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11
4th week of month
Mo 15
Tu 12
We 3
Th 5
Fr 21
Sa 2
Su 11
5th week of month
Mo 23
Tu 12
We 30th day of current month) 3
Th (1st day of next month ) --
Fr (2nd day of next month --
Sa (3th day of next month --
Su (4th day of next month --
Nov 13 '05 #1
0 1254
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
Data Input Database Design Help
by: Mike | last post by:
Hi I have been tasked with converting my pulp and paper mills weekly projected and actual contractor hrs excel spreadsheet into a an Access 97 database. So far my design has been to use a...
Microsoft Access / VBA
0
Dr. Dobb's Python-URL! - weekly Python news and links (Apr 10)
by: Peter Otten | last post by:
QOTW: "You need 23 C/C++ people to do the job of one Pythoneer ;-)" - Jorge Godoy "I've never seen an 'object-relational mapping' ... which doesn't drive me into a murderous, foam-at-mouth rage...
Python
0
Dr. Dobb's Python-URL! - weekly Python news and links (Apr 17)
by: Peter Otten | last post by:
QOTW: "Discussion about Python 3000 is heating up. What I haven't seen so far is a list of things that will be dropped from the language to make room for new ideas." - Greg Wilson "The longer I...
Python
0
Dr. Dobb's Python-URL! - weekly Python news and links (Apr 24)
by: Peter Otten | last post by:
QOTW: "Going from Python to Java (as it's in my case) is real pain I wish nobody to feel... Even with multi-million support for Java from giants like Sun, IBM or Oracle, I find it much easier to...
Python
0
Dr. Dobb's Python-URL! - weekly Python news and links (May 1)
by: Peter Otten | last post by:
QOTW: "I have a certain fondness for the first over-100-lines module I wrote for Python" - Alex Martelli "Programmers should be paid by the amount of code that they avoid writing." - Michael P....
Python
0
Dr. Dobb's Python-URL! - weekly Python news and links (May 8)
by: Peter Otten | last post by:
QOTW: "If you can find a workable solution not involving metaclasses and decorators, don't use them" - Michele Simionato "Newest Beautiful Soup beta solves everyone's problems that I know of." -...
Python
0
Dr. Dobb's Python-URL! - weekly Python news and links (Jun 20)
by: Cameron Laird | last post by:
ANNOUNCEMENT: we had an incident with backups of the "Python-URL!" mailing list. It's possible we lost one or two transactions from the last week. If you aren't receiving an e-mailed copy of...
Python
3
Running average for weekly Dollars
by: mochatrpl | last post by:
I am looking for a way to make a query / report display the running average for total dollars. I have already set up a query to provide totals dollars per day from which a report graphly shows...
Microsoft Access / VBA
6
Python-URL! - weekly Python news and links (Apr 30)
by: Cameron Laird | last post by:
QOTW: "That is just as feasible as passing a cruise ship through a phone line." - Carsten Haese, on transporting a COM object across a network. Less vividly but more formally, as he notes, "A COM...
Python
1
issue with creating a weekly report
by: associates | last post by:
Hi, I desperately need your help here. I'm trying to work out a better way of producing a weekly report for a job that should show the weekly activities for last week and the current week using...
Microsoft Access / VBA
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
Changing the language in Windows 10
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...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
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...
General
0
agi2029
AI Job Threat for Devs
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,...
Career Advice
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!