Tel: 916.726.5675

Access

	Access Group Home
Get Started Page eMag: Access Edition Highlights WEEKLYLESSON Week 45 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Access KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Access News Resource Links ACCESSTIDBITS: All as FlashCards Code Snippets FAQs Tips

	Access To/From
To/FromCODEGuides Access To/From

	Access Study Test
PRESTWOODCERTIFIED Access Study Test

	Access Store
PRESTWOODSTORE Store Home Buy Access Items

	Members Only
MEMBERSONLY Access Member List Member Only KB Posts Access Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

Prestwood eMagazine

November Edition

Subscribe now! It's Free!

► MB Lobby ► Microsoft Access Board ► MS Access Interactive Topic

Print This

Query help (again)

Query help (again) in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: (again) Query (again)

Add Reply

[Who's Read This]

Add New Thread

Random Thread

Most Recent Post

Query help (again)

Post ID #14407, No Replies Be the first! 12/13/2010 7:47:26 AM

Wade.G

Ankeny, -- UNK

I have 2 tables, one (tblLOCProfile) is a list of locations, start day, and end day (LOCATION, StartDay, EndDay). The other table (tblDailyData) consists of a list of locations and a temperature reading for each day of the year (LOCATION, DayofYear, TEMPERATURE).

What I want to do is get an average of TEMPERATURE for each location based of the Day of Year range (StartDay, EndDay) from the first table. THe kicker is the StartDay and EndDay may be different for each location.

Any ideas of how to go about constructing such a query?

Thanks,

Posted 15 years ago (Thread Starter)

Comment

Quote

About Wade.G

Visit Profile

Approved member.

Member subscribes to this thread with a verified email.

Old Account!

If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.

Web Presence Hidden.

Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #14407, No Replies Be the first!

Thread Started 12/13/2010 7:47:26 AM

View Counter=2645

Location=Ankeny, -- UNK

Joined=15 years ago MB Posts=2