Recent content by JordanR

Jal, What I'm going for is a SUM of daily data into weekly data Summing numerical values that I have for Monday, Tuesday, Wednesday, etc into a value for Week 1, Week 2, Week 3 (of the year). the problem is that a "week" is Monday through Sunday instead of Sunday through Saturday.

Nope, looks like you were missing a parenthesis in your latest post. I added it back and get the same results.

Still can't figure this out. If you have any more ideas, I'm all ears.

Closer and closer I get. I realized I had the stupid security settings turned on, so the function was disabled. I got rid of that nonsense and now when I run the query it runs, but no data is returned. To explain a little more, the table looks somethign like this; InDate InTime...

So I copy/pasted the code into functions. Then created a new query with the following: SELECT Sum(HourlyIn.[numberofstuff]) FROM HourlyIn WHERE ((HourlyIn.InDate>=fnFindMonday(DateAdd("w",-1,Date())) And (HourlyIn.InDate<=fnFindSunday(DateAdd("w",-1,Date()))))); And all I get is undefined...

It does, but I'm not sure how that translates to the Query screen. If I had to do this in VBA, I think what you're describing would help me. But I'm not sure how I'd define WeekStartDate so I could do that calculation

Title kind of says it. I have a table with: InDate, InHour, Data1, Data2... etc. I wanted a query that would summarize the data up into weeks, but what makes it more difficult is a "work week" is Monday-Sunday. Any easy way to do this?

This may be a silly question, but when I do a query that sums Access of course renames the heading "Sum of Blah." Is there any way to stop it from doing that? I know I can name it back by putting an expression in the query, but I have two HUGE queries that would make this extremely cumbersome...

I played with something like this as well. It worked, but it still didn't give me the date on the x-axis. Am I missing something obvious?

Clearly I'm missing something. Using Excel 2k7, I have a named range - DDI_Con with the following formula =OFFSET('DI'!$D$1, COUNTA('DI'!$D:$D)-90,0,90,1) Reference that in a chart and I get just what I want, a graph that shows me the last 90 days. Problem is that I can't get the x-axis to...

I've been playing with all of them and I may be missing something. The goal is, obviously, to perform lookups based on data that I have in a table. So if I have a table Jan 06 Feb06 March06 Stuff 5 4 9 Things 6 5 1 Firstif I want to find out what...

Wow, sorry I didn't come back to check on this answer. This is outstanding and helps a great deal! Thanks.

THAT was way too simple. Boy did I overthink that one. Thanks.

I'm importing log files that don't have a date field. I was thinking the easiest way to fix this is to run an import, then do an update query to add the date (today's date)to any records that have a null value for that element, but I have no idea how to do the update. Importing isn't an issue...

Kind of lost here and hoping for some help: I get a list, every day, of items that I need to track their placement (or rank) on the list. I've tried looking into the Rank function and I've even used a forumla to just give me a numbered list and they work relatively well. Problem is that I have...