Search results

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

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

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

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

Here's what I got: Table1: Case_ID, Duration Table2: Case_ID, Notes_ID, Date, Duration Table1.Duration is populated with numeric values Table2.Duration is currently blank Table2 may contain many notes for each entry in Table1. I want to take the values of Table1.Duration and Update the last...

Looking to have a time field that a user can enter how long they worked an issue. Format should be ##:##, but I'm afraid that if I use text, calculations will be impossible. How does someone do this if it's expected that the value will frequently go over 24 hours?

I may be oversimplifying my idea here, but I'm trying to have Form A, which has a source of Table A have fields automatically filled out with values from Table B when I select a template name and click a button that's on Form A. I simply have no idea how to make something this simple happen...

I’m working to ever-improve a Help Desk-like database and I got this idea for “templates.” That is, a quick way to fill out the as much of the ticket form as possible when common issues come in. So I’ve created a table (Templates)that mimics the structure of my ticket table (Incidents). I’ve...

Same database as all my other questions, but this time the request is that each case has a duration field. Is there an easy way to have a single query give a count of how many cases were considered light, medium or heavy given that light is a duration of 0-2 hours, medium is 3-5 hours and heavy...

I have a query setup: SELECT Format([RepDate],"mmmm yyyy") AS [Date Reported], inc_Incident.Category, Count(inc_Incident.Category) AS CountOfCategory FROM inc_Incident GROUP BY Format([RepDate],"mmmm yyyy"), inc_Incident.Category, inc_Incident.Status HAVING...

Still fighting to understand a darn thing about treeviews. What I was hoping to do was create a kind of knowledge base that I could integrate into a larger database I'm using. I wanted for each entry to have a category, short description and then longer details. Then for the treeview to display...

I have a search form (Form A) that as I type in a text box the contents of the listbox refreshes to show only those items that match the text in the text box. When you double click on any of the items in the listbox it jumps me to a detail form based on the ID field. On the detail form, there is...

I'm sorry if this isn't the correct forum to be posting in, but I wasn't sure where "I'm very familiar with Access, but I need to do X and I'm not even sure where to begin"-questions go. I need to create a database that collects monthly metrics for an entire team. So I setup tables met_Metrics...

I have a form, with a tabbed interface. On each tab is a subform showing a continuous form with records matching criteria. I'd like for the name of each tab to also include a count of the items in each subform on each tab. Is that possible? So the name of tab 1, instead of "Opened Cases"...

I've read everything I can get my hands on about securing a database, and I think I have it all implemented the way I want, but my users can still do one thing I don't want. It seems really simple, but I can't find a way to stop my users from accessing a table from the database window. They...

Trying to setup a treeview and it's hurting my brain. So here's hoping people can help. tblReviewers Reviewer_ID Reviewer_Name tblCases Case_ID Case_Description Reviewer (Stores the value from tblReviewers.Reviewer_Name) I want a Treeview where the parent nodes area a reviewer's name and all...