Recent content by Paul_Bricker

Assuming all fields are Text datatype try this "[MenuCategoryID] = '" & [Forms]![Searchform1]![MenuCategoryID] & "' And [TypeofCourseID] = '" & [Forms]![Searchform1]![TypeofCourseID] & "' And [CourseCodeID] = '" &[Forms]![Searchform1]![CourseCodeID] & "' And [BrandCodeID] = '" &...

Try pasting this back in. WHERE (((tblAPPLICATIONS.[DATE OF DECISION]) Between DateSerial(Year(Date())-1, Month(Date()) + 1,1) And DateSerial(Year(Date()), Month(Date()) + 1,1)-1)) GROUP BY tblAPPLICATIONS.SPECIALIST, tblAPPLICATIONS.REPORTS; I added a couple )) at the end of the Between...

Mike, this should get you close. WHERE (((tblAPPLICATIONS.[DATE OF DECISION]) Between DateSerial(Year(Date())-1, Month(Date()) + 1,1) And DateSerial(Year(Date()), Month(Date()) + 1,1)-1 Paul

Well you could try this. Put this expression in the Control Source for a textbox in the Group Footer or the Report Footer. =Sum(IIf(InStr(1,[MyField],"MyString")>0,1,0)) See if that works. It should, I just tested it. Paul

That's OK. Glad you got it working. Paul

It's probably a translation problem. Although I used the Date() function, it probably copied and pasted as just the word Date. Go thru the statement and add the () to the Date part of Date() - [Date Received] If that doesn't work then retype the whole function Date() Paul

Mike, try this and let me know how it goes. I think maybe there was a typo someplace in the other one. SELECT tblAPPLICATIONS.[DATE RECEIVED], tblAPPLICATIONS.MEMBER, tblAPPLICATIONS.SSN, tblAPPLICATIONS.SPECIALIST, tblAPPLICATIONS.[DAYS OLD], Format(Int((Date - [Date Received]) / 365), "00")...

Bob I'll defer to you on this if you've seen it. Plus yours is easier to read. Paul

It's calculated in the Report. OK, I'm scratching my head here a little. How do you get the value into the table. Do you use an Insert Into statement when the report is run? When you open the table tblApplications, do you actually have values stored in the [Days Old] field? It's possible you...

Sorry, I missed the comma, but I'm not sure why it wouldn't return any values. What is [Days Old]. Is it a numeric field? Is it text? Is it calculated in a query and stored in the table tblApplications? Paul

Assuming you want to use [Days Old] as the field to test on, it would look like this. SELECT tblAPPLICATIONS.[DATE RECEIVED], tblAPPLICATIONS.MEMBER, tblAPPLICATIONS.SSN, tblAPPLICATIONS.SPECIALIST, tblAPPLICATIONS.[DAYS OLD] Format(Int([Days Old]/365), "00") & Format(Int((([Days Old] Mod 365)...

I assume that you want to calculate Days from the query. You may or maynot be able to do it using this because Days is a Calculated field. SELECT tblAPPLICATIONS.SPECIALIST, tblAPPLICATIONS.REPORTS, Avg(DateDiff("d",[DATE RECEIVED],[DATE OF DECISION])) AS DAYS, DateAdd("yyyy",-1,Date())+1 & "...

You can use this expression. The count will not be 100 percent accurate depending on what corrections you make for number of days in a year and number of days in a month. I used 365 days in the year and 30 days in a month. Format(Int([NumberField]/365), "00") & Format(Int((([NumberField]...

Wayne's suggestion is a very good one. This reply is just to troubleshoot your string. Try this (it doesn't seem to format properly in Preview but you should get the idea). stDocName = DLookup("[Report_Name]", "Report_Config", "[Report_Group_No] = " &...

DaG, on the menu bar in your database go to View...Toolbars...Customize. Under Categories click Form/Report Design and under Commands you will see an icon for Save As Report. If you put this on your toolbar, you can save your Form/Subform as a Report. This may get you where you want to go. Paul