Search results

Hi, I am making a chart that is grouping data by week with the weeks being the labels on the X axis. I have tried it as both a pivot chart and a chart wizard onto a form. Currently the labels look like, 47 '10, 48 '10, 49'10, etc. This doesn't really work that well for the people that will be...

I have a table with a process date. I have another table in which each record has a start date and an end date. I was wondering how to make a field in the table with the process date that would tie back to the other table based on the date range. I've tried using SQL in the lookup for the...

I've been racking my brain trying to think of the best way to do this, but have no idea how. I have line items that get audited with different frequencies (i.e. Monthly, Mondays, Twice a week, Every 2 weeks). I'm trying to get a query that will show which ones have not yet been entered for a...

I've been racking my brain trying to think of the best way to do this, but have no idea how. I have line items that get audited with different frequencies (i.e. Monthly, Mondays, Twice a week, Every 2 weeks). I'm trying to get a query that will show which ones have not yet been entered for a...

I currently have a query that should be pulling everything from the past month. I have it extremely close except for some reason it pulls in 6/4/2010, 6/7/2010, 6/8/2010, 6/9/2010. My criteria in the date field is Between Date() And DateSerial(Year(Now()),Month(Now())-1,Day(Now())). Any idea...

Hi, I have two questions in regards to filtering a query based on my form. I currently have this "working", but not the way I would like. I have the criteria of a field in my query set to "LIKE Forms!Form!Subform!Field" & *. This works, but only returns the first filtered value from the form...

Hi, I have a form with four subforms on it that are all filtered when the form opens. When a button is clicked I would like to have each subform exported to separate sheets in a new excel workbook. I have been looking all over trying to figure it out, but can't find anything. Thanks