AimeeRae
Last Activity: Feb 28 '07, 02:12 PM
Joined: Feb 5 '07
Location:
-
Thank you!!! Sorry for the delay! I just saw this now!... -
Access Reports -- Getting the dates to go horizontally and not vertically
I need to create a report based off the following table (column headings):
Station/Date/TransType/Offer1/Offer2
Station can be either: (KTTB or WOA)
Date is variable
TransType can be either: (Inquiry, lead or new order)
Offer 1 is a number
Offer 2 is a number
I need the report to have the station running vertically down the page with offer 1/offer 2 and the date to... -
Unfortunately, I do need the "Unsourced" information. I need to see how many responses are considered "unsourced. The response being linked to both airings is not going to be an issue. We will never have 2 airings that close to each other. So here is my second attempt at SQL:
...Code:IIf((tbl_Airing.Station = tbl_Responses.Station), And (tbl_Airing.[DoA] = tbl_Responses.[Trans Date]), (tbl_Airing.[ToA]-tbl_Responses.[Trans
Leave a comment:
-
=)
So I will need to link tbl_Responses and tbl_Airing by Station and by Date, then do an IF statement to link my response times to my airing times. I wrote this:
...Code:SELECT tbl_Responses.Station, tbl_Responses.[Trans Date], tbl_Responses.[Trans Time], IIf(([tbl_Airing.ToA]-[tbl_Responses.Trans Time])<=#12/30/1899 0:30:0#,[tbl_Airing.ToA],“unsourced”) AS Expr1,Leave a comment:
-
You think of EVERYTHING! =)
Actually, there will only be one Ad running per station, however, I will need to link the Station on the Airing table to the Station on the Responses table. They will always be in the same format: (KDWB-AM or WLS-AM...3 or 4 letters and AM/FM).
Thanks!!! You are such a great help....Leave a comment:
-
Writing a Query based on times in two different tables
Ok. Another tricky Access question. Same database, different querry.
I have a table called tbl_Responses and my tbl_Airing…simi lar to my question about linking Airings to Rates, I now need to link Airings to Responses.
For example, an ad airs on 2/12/2007 at 7:05am,10:20am, 1:45pm, 3:55pm, 8:20pm(this data will be stored on the Airing table). From that Airing, I get 34 responses with differing times through out... -
Thanks again!!! You are the best. Have a great weekend....Leave a comment:
-
Sorry, I should have been more specific. It is the Total Rate(sum) for each station on a daily basis. You have been so much help. Thank you!...Leave a comment:
-
Thanks for explaining that calculation! That helps alot. The only problem I'm having now is that there are several rates showing up for each day (which is correct), is there any way that I can add into the formula something that would just give me the total rate for the entire day's worth of airings?...Leave a comment:
-
YOU ARE A GENIUS! THANK YOU SO MUCH! IT WORKED LIKE A CHARM!...Leave a comment:
-
Perfect! So I just change the name of the fields and copy SQL into the "criteria" field in my querry? Thank you! Thank you!...Leave a comment:
-
Thanks Rabbit! the only problem is that the Rates database is already set up with thousands and thousands of rows of data. It is set up with the headers:
Station: Mon-Fri 6am-10am: Mon-Fri 10am-3pm: Mon-Fri 3pm-7pm: Mon-Fri 7pm-12am: Sat 6am-7pm: Sun 6am-7pm:
The Rates are already tied to the Mon-Fri 6am-10am etc. So how would could I make the time start and end in separate columns without losing the rate information?...Leave a comment:
-
Date and Time Expression Help with Access
Hi Everyone-
I need to figure out how link up a date and time in one database to a specific value in another database. For example:
I have a radio station ABCD that aired an ad on Monday, Feb. 5th at 2:04pm. We pay out specific rates depending on the time of the airing. The rates for each station will vary depending on the station/day and time. In one database I have the airings that are set up like this: (example...
No activity results to display
Leave a comment: