Search results

OK, PNGBill, hope you have not forgotten me. Sorry for the delay in responding. Was playing firefighter last several days. Attached is another copy of the database. If you look at the Query named Qry_PendingTruePres by Weekending. This query will pull the number pending by weekending date so...

Thanks. I will clean it up a bit and put another sample on. Too many fires to put out today to work on it. I will try again tomorrow. It is 4:25pm here and time to go home. I am in Arizona. Where are you? Thanks David V

Try this version. Hope you can open this one. Thanks David V.

We just updated to 2010 a few weeks ago. We had 2000 until then. I stil have 2000 on my pc, so I will try to save a copy in that version for you. Thanks David V

I appreciate your patience with me. I attched a copy of the database to this thread. If you can open that, then refer to the queires. The queries are called Qry_PendingTruePres by Weekending Date, Qry_PendingBBB by Weekending Date, Qry_PendingVerbals by Weekending Date. and Qry_Pending CRLS by...

Thanks for the info PNGBill, I somewhat get what you are trying to do. I was able to create a query that returns the week number for each issue based on the Issue date. My problem though, is that the pending number changes daily, new issues are received and issues are closed. Right now, the...

Thanks PNGBill. I was wondering if you could be so kind and provide an example. I checked out the link you attached, but found it confusing. I am going to google WeekNum to see if I can find some more information about that. Also, not sure how the reporting part can help me with this issue...

I am trying to write a query that will provide the oldest date by weekending Date. I have a report that goes out weekly that lists the #received, #Completed, #Pending, and oldest date. If I only do one week, it is easy. But once I add the 2nd, 3rd, and 4th week, it becomes difficult. Attached is...

I am having trouble suming the results of a query. I have a query that determines the # of Workdays between 2 dates and is returned as days, hours, minutes. I need to sum these to get total and then divide by the number of issues to determine an average Turn around Time. Her is what i have so...

Good afternoon HiTexhcoach. This code is 90% perfect for an Issues database I am building to count workdays between the start of an issue and the end. However, need some help in tweeking it a bit. Would like it to return the number of days in DD/HH/MM instead of just days. For example...

Thanks Steve, you are right, when I ran it again, it worked. Well, That was my test method, now I would like to add this to the real database, but want to use it on a submit button that is already built. I tried copying the code into this button, but get this error. "Duplicate output...

Thanks Cynthia, Your directions helped me get the tables and queries set up. I now have an append and delte query. My problem now creating a button that will run both queries. Unfortunately, my knowledge of access forces me to use the wizard when creating a button. The wizard will only allow...

Hi Cynthia, I am trying to create something exactly what you describe here. Unfortunately, I am a novice and do not quite understand your steps. Basically, I just want to be able to click on a delete box, and have it remove the item and place it on another table named "Deleted Items". Having...

Help, I am having nightmares about this report. It is called a Standing Report and a sample that we are currently using in excel is attached. I need to try and build this report in access. I have the queries built that will pull the data, but the report will only show 1 week at a time and I...

Good Afternoon MissingLinq, your suggestion is exactly what I am looking for, but after following your instructions, it did not work out. I still have to type the associates last name into the parimeter value to pull the form. To help you help me, I have attached a copy of the database. The...

OK, I have a form that is created form a query to pull data on an associate. Currently, when you click on the form, you have to enter the associates last name to pull the data. Instead of typing in the last name, I want a dropdown box so all the auditor has to do is click on the name of the...

Great, thanks. I did remove what I had because it did not work. That is why the control source was blank. ANyway, this looks good. Now, I just need to add a button to open the report, right? Thanks David V.

SOrry to bother you again Wiklendt, but I cannot get this datePicker thing to work. I am not sure what I am doing wrong. I have followed your instructions, but still cannot get it to work. I have a form and named it frmDatePicker. I want to attach it to the bjwQry_CompletedTruePres Select Query...

I am having trouble creating a form that will updatee several queries at the same time. Does anyone have any suggestions on how to do this? On one form I will need to enter a start date and an end date and on another form, the start date and end date will be the same day. ANy help is greatly...

Hi Wiklendt, I hope you are still around. Have a question about above. Can this work when I need to update 8 queries with the same start and end date? I have a report that needs 8 queries to get the results, so I would need to update 8 queries with the same start and end date. Hope you can...