Search results

Table1: Case_ID is an autonumber Table2: Notes_ID is an autonumber

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

Not quite what I'm looking for. I'm just trying to make a field where someone can enter how much time they've spent on an issue by saying 1:15 instead of 1.25 when trying to say 1 hour and 15 minutes or 27:45 instead of 27.75. My complication comes in that I will invariably have to do math with...

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?

The problem with that approach is that only a handful of records will be based on a template. Most of them will be unique entries. The templates are just meant as a way to rapidly fill some of the fields for some of the cases. Example: I have this form doing what I want but I'm only able to...

I think you may be misunderstanding, data is not being duplicated between the two tables. Let me try to explain again. TableA: Case_ID Date Customer Name ShortDescription LongDescription Classification TableB Template_ID TemplateName ShortDescription Classification FormA is based on TableA...

I can think of a couple ways to do it, but first is there any authentication going on when the users access your database? If not, then you should be able to just go with an inputbox. If the value they put in matches the password perform the action requested. Bear in mind, that by not doing...

Will that work? My intent is that once they pick their template and click the button, the fields get filled out but by the values in Table B the record is then stored in Table A. I'll try out your idea, but I'm not sure I see how it will work out.

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

Ok, I got further thanks to reading Gibbo's explaination a few times. Thanks man, I was just being thick. So it looks like it should work, but I keep getting an error. When I pick an item from the combo box and open the query into datasheet view, it looks like it's going to populate perfectly...

Any help? Anyone? I'm just not seeing how to do this.

Thanks for the assist. Gibbo, I think you're closest to what I'm looking for. I'll try to explain again and hopefully clear up some confusion. User goes into the database and clicks a button to create a new (blank) case. Blank form comes up. On the right side of the screen there's a combo...

Thanks for the assist. Gibbo, I think you're closest to what I'm looking for. I'll try to explain again and hopefully clear up some confusion. User goes into the database and clicks a button to create a new (blank) case. Blank form comes up. On the right side of the screen there's a combo...

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

But I want to get a query that returns: Light Cases 5 Medium Cases 7 Heavy Cases 2 Or whatever. I'm not trying to find out IF a case is high, medium or low. I'm trying to get a count of cases that fit each criteria, and wondering if that can be done in a single query.

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

Yea, man. I think I got it. Thanks so much for the help.

Thanks so much, Pat. The reason I don't have Status in the SELECT is because I need that condition, but I don't want the results displayed. There a better way to do that? Also, I just tried it and it seems to calculate the date like a champ, but I'm not getting unique counts for the month...

Thanks for the help, everyone. But I am getting a syntax error. Here's what I have 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...

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