473,385 Members | 1,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Quarterly Date Field

Our team does numerous tests each month. Each person can run a report to automatically tally up all the results for the quarter. I have then created a Form specifically to enter our Analysis for the Quarter because it goes up to the CEO (so I seperated it because it has to have many revisions with our comments). For the Date Field I can't figure out the best way to put the date together for the Quarter.

Options I have come up with:
1. Create a drop down that have numbers 1-4 for each quarter than have a second field for the Year. Then in my Query could put them together.
2. I could just leave it as a Date field and let people enter dates in there and I could run a query to pull in all data between those dates.
3. Create another table altogther that has 1st Quarter 2008, 2nd Quarter 2008, etc and have a drop down box for each of the quarter than run the query that way.


Anyone have any other ideas or is one of these options above the best option I have?
Mar 27 '08 #1
2 5420
PianoMan64
374 Expert 256MB
Our team does numerous tests each month. Each person can run a report to automatically tally up all the results for the quarter. I have then created a Form specifically to enter our Analysis for the Quarter because it goes up to the CEO (so I seperated it because it has to have many revisions with our comments). For the Date Field I can't figure out the best way to put the date together for the Quarter.

Options I have come up with:
1. Create a drop down that have numbers 1-4 for each quarter than have a second field for the Year. Then in my Query could put them together.
2. I could just leave it as a Date field and let people enter dates in there and I could run a query to pull in all data between those dates.
3. Create another table altogther that has 1st Quarter 2008, 2nd Quarter 2008, etc and have a drop down box for each of the quarter than run the query that way.


Anyone have any other ideas or is one of these options above the best option I have?
You simply take the field that displays the date and create an expression to display the quarter number 1 - 4 and the year. ex TheQuarter:=format([Name of date field],"Q/YYYY")
Mar 29 '08 #2
You simply take the field that displays the date and create an expression to display the quarter number 1 - 4 and the year. ex TheQuarter:=format([Name of date field],"Q/YYYY")

Thanks for your help....

Matt
Apr 2 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: tran.loan | last post by:
I have a reporting query that I need to do a quarterly trending on. A user enters a begining date and end date, and from there, I have to determine the closest quarter to it. Also, the actual...
3
by: BlackFireNova | last post by:
This concerns an Access 2002 (XP) database. There are two fields, "Notes" (Memo Field) and "Notes Update" on a form (among others) which I am concerned with here. Problem: I need to be able...
3
by: captain | last post by:
Below is the sql for data with same date need to extract + or - 5 days data of same date also. How to also get data of + and - days related to same date. SELECT IM.Area, IM.Location,...
1
by: PeteCresswell | last post by:
A "quarterly return" is the decimal amount that an investment returned over a given three-month period. The periods end on Mar, Jun, Sep, Dec Seems like there are a couple of ways to link a...
8
by: Laura | last post by:
I am working with a Business Development database. We need to generate a new report showing forecasted revenues by quarter. The data I am working with includes: Project, Revenue, POP Start, POP...
6
by: Luvin lunch | last post by:
Hi, I'm new to access and am very wary of dates as I have limited experience in their manipulation and I know if they're not done properly things can turn ugly quickly. I would like to use a...
1
by: BuckBaxter | last post by:
In Access 2003, I'm trying to provide quarterly reports from an Orders Table. I made a query where OrderDate criteria is "between 01/01/06 and 3/31/06" which works for the first quarter. How do I...
1
by: egrill | last post by:
I can access the date field from OBCC tables and do the normal date range for a quarterly report for each quarter I need the formula so I can sort the records into individual quarter having them...
5
by: sparkbrook | last post by:
I'm trying to write a simple Access program that stores details of customers that have service contracts, payable monthly or quarterly (customer's choice). The program needs to print monthly or...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
marktang
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,...
0
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...
0
Oralloy
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,...

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.