Search results

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...

Hands down the best program for databases on the PDA is SprintDB. Huge fan of the program. It's incredibly powerful. Only catch, which holds true for all PDA database programs, is forms and queries don't synch. Oh.... SprintDB is for PocketPC only.

Nah, the idea is that I need to keep inserting colums for week1, week2, week 3, then delete those columns and put in a new column for the month, which summarizes the month's activity, and the last column does mathmatical comparisons of the last two columns. Doing this has gotten really annoying...

Is there a way to setup a calculation in a cell that looks to the left of it for the last two non-blank cells and performs the calculation? Example: Cell D1: {First non-blank}/{Second non-blank} Cell A1: 50 Cell B1: 100 D1 would then equal 2. If I then entered 2 in C1, D1 would then change to...

I'm writing a task tracking database to be used during staff meetings. Each task should be assigned a priority, and no two tasks should ever have the same priority. Easy enough. Here's where I could use some suggestions. If I have a new task, what would be easiest way to manage that insertion...

Bump.... any help? Anyone?