I have a data base where we keep track of radio ads that we run. Say the radio spot runs starting Jan. 1 and ending on March 31. I want the report to list January and the dates of the radio spot and then say it runs thru March. I want to have a heading that lists Feb and March. I know how to get the month for the start date but in this case the end date is important to us to.
Thanks
7  2000 
I don't understand your question. If you are trying to get the end month, and you know how to get the start month, all you have to do is copy what you did to get the start month and replace the start date field with the end date field.
Okay - If I want a schedule pulled from this....we have a radio ad that runs from Jan. 1 thru Mar. 31. I want a report that shows my ads for Jan., Feb. and Mar. Currently I run the report by the start date, but I want the months in between too. Does this make sense?
I think you're going to have to be more specific. All I can say at this point is to run the report by start date and end date. To truly understand what you are asking for, you need to show us the SQL you're using, some sample data, sample results from that sample data, and table/field definitions.
Do you have a table that keeps track of the ads that have run? If you have a list of ads with their corresponding dates, you can just group your records by date on your report and select "by month" in the grouping options. Use the id field for the specific ad in question to filter the records in your query.
@GKJR
Yes, I do have a table, but when they put in the start date it might be 1/1/14 and the end date might be 3/31/14. So this billboard ad runs continuously until 3/31. When I created the schedule I had it pull by the month so they knew what was running at a glance and if we had any months open - so the schedule misses Feb. & Mar. unless they enter it with just one month at a time, which is time consuming for them. Thanks for your help!
So when they create a record they are only choosing a month instead of an actual date? That doesn't seem to be the best way to do it. With a date picker box it should be easy enough to choose an actual date, such as the last day of the month. You could display any date by the month it is in with formatting or using the date functions in VBA.
Do you have two different tables storing this data? To me it sounds like start date and end date should be stored in the table for "Ads", and you should have another table for "Ad Occurrences" or whatever you want to call it. This table would reference the AdID in the Ads table.
If you base your report on the table for Ad Occurrences (your query should still have the "Ads" table in it - join by showing all records in Ad Occurrences and filter by Ad Name in the Ad table), then you could create a group for the "Ad Date" and choose the option for grouping by month. The header in this section would then show the month, and the detail section could show the actual date and any other fields you want to include. You can put a text box control for the date in both the header and detail sections.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Chris Curtis |
last post by:
We have a program which is used to upload data to our website.
A report file is saved each time and is supposed to reflect the date!
Not being a java programmer I think the following code is used...
|
by: Michael Riggio |
last post by:
Is there a way to create my own Start Menu bar, kind of like the ms office
toolbar?
|
by: Warren |
last post by:
I am trying to create a report that does the following:
Access Data in Query:
NAME | DATE | SALE TYPE |
-------------------------
John DOE | 1282003 | TYPE A
Jane DOE | 1282003 | TYPE C...
|
by: Sara |
last post by:
I have followed instructions on the http://allenbrowne.com/tips.html
for limiting a report to a date range. At the bottom there is a note
that says
You will end up using this form for all sorts...
|
by: MLH |
last post by:
Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?
And if the answer is Yes, how much actual time
is being added to the date function in this assignment?
|
by: Me |
last post by:
I need to get the past 5(x) months for certaing calculations. What I
have is listed below:
########################################
my $year, $month_str, $month_int;
foreach my $count...
|
by: T |
last post by:
I'm trying to determine the useage of varioius reports I have. I need
the following to occur when a report is opened, get the name of the
report, datetime, username.
I created a tblLog...
|
by: dkyadav80 |
last post by:
hi sir,
I have following problem:
code goes here:
{code]
1.
<html>
2.
<body>
|
by: mulamootil |
last post by:
Hi friends, I am new to access and I need to create a report. Please pardon me for such a long post.Appreciate your patience.
I have a table in Access (MyTable) with data about products...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
| |
