Search results

Thanks Galaxiom, this is perfect. I have to create another query to sum the numbers, but this will do fine. I thought that I had tried this once before but may have done something wrong. Again, thank you so much. David V

I have read several threads related to this problem and have tried them all. From DateValue to CDate, to others. None have worked. I need to create a query that will count the number of items that meet certain criteria. This is what I currently have: SELECT Count(*) AS [#Closed Debt...

Thanks VilaRestal, I tried this real fast, but could not get it to work. I am heading home now, but will try agian tomorrow. The other thing I wanted to mention was that I am using a Date picker so the associate can select the begin date and end date. The form is call frmDatePicker. The...

I have a table of data that has a column that uses Date/Time of when received. This table is in a SQL database. I have linked the table to an access database so an associate without sql skills can pull reports. Problem is the form to pull the report requires to enter the begin date and time...

Thanks Shawda for posting this. I was able to utilize this on one of my forms. Thanks

Still pulling my hair out over this. Please, if anyone can assist. I have seen some threads that are real close to what I am looking for, but I am unable to apply the formula to my queires. I have #ofIssues: Count(*) that I think I need to apply the NZ function to. Bob Larsen had this in a...

Thanks Bob for the quick reply. I studied your query and still could not apply it to how I need it. I thought to give you a better sample. I have attached the database that includes the form "datepicker". In still using the date range of 10/31/2010 to 12/25/2010 and associate JJJJJ on the...

I have asked for help in the NullToZero function before, but for some reason I cannot apply what I have learned to a new situation. I need to create a report that will show records for weekending date even if there were no records recorded for a week or 2. I have attached a copy of the sample...

Thanks Bob, I tried this and this makes sense. However, I am still getting an error. It is now the error "#Type". Not sure why this is happening. Thanks David V.

I have a main report that shows an associates peices per hour worked (PPH). The associate is rated based on a scale that is determined by the departments average PPH. I have created the scale as a subreport on the main report. Example of scale= Associate receives a rating of 3 if their pph is...

Thanks to the both of you. I ended up creating a subreport and added it to the daily report. This will suffice for now, but I do want to make it more simplified. I will try the other suggestions tomorrow. I did put an = sign in front of the string that I added to the control source. I also...

Thanks Bob, still no luck. I am getting an error that states "The expression you entered contains invalid syntax. You may have entered an operand without an operator. I also tried adding it to the query, but my query already sorts by oldest date by associate, so I could not do that. I do...

Thanks Bob for the quick replay. I think this will work, however, I need to know how to place it into the control source of the text box that I created on the report. I tried what you provided, but I got errors. How would you enter this into the control source? Thanks

I have a report with 4 columns that contain dates. I need to write an iif statement that will return the oldest date of the 4 clumns. I have tried =Min(expression), but this only allows 1 argument. I have 4 arguments. The column headers are TruePresOldestDate, BBBOldestDate, VerbalOldestDate...

Good Morning, I have attached an updated version of the database. There are Queries for each issue type for pending. They are Qry_PendingTruePresTest, Qry_PendingBBBTest, Qry_PendingVerbalTest, and Qry_PendingCRLTest. It is set up to enter the weekending date to get the figures. For example...

I appreciate the example. I guess to throw out a challenge to the Access experts, I would give the following problem. Using the table called "TblIssues" in the sample database that is attached to this thread, can you write a query that will give me the number of True Pres Issues pending as of...

Good Afternoon, I appreciate your taking the time to look at this thread. I have a report that is to state the numbr of issues received, completed, pending, and oldest date by Weekending date. For example, using August. For week 1, I would use start date 8/1 and end date 8/7. Week 2 would...

My original plan was to include the query on the main query that pulled all information. Problem with that though is that the received and completed information is pulled by using a start date and ending date. The pending and oldest date queries are pulled by weekending date. So basically, I...

OK, Looks like the number pending for True Pres issues for Weekending 8/7/2010 was 30. I did this query: SELECT TblIssues.IssueType, Count(*) AS [#Pending] FROM TblIssues GROUP BY TblIssues.IssueType, TblIssues.IssueDate, TblIssues.CompletedDate, TblIssues.BBB HAVING...

Thanks PNGBill, I am going to get in touch with the auditors that works this report via excel and find out why the descrepency. I did the same thing you did and the result seem to be correct when you sort by weekending date. I think the problem is with the report that I am trying to compare it...