Search results

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

My apologies for not putting my reading glasses on before I read your question. The expression I posted will not differenciate between Is Null and Is Not Null. Are you trying to do this because the Form won't display a list of values for any fields when you use Filter By Form except Is Null...

On the criteria line try =Forms!multipleselectform!ControlNameHere Or Forms!multipleselectform!ControlNameHere Is Null I think that's the syntax you want. Of there's a problem, take out the space between Is Null and make it IsNull. But I think it's Is Null. Paul

Brian is very close Try this "This " & Format(dteholder, "d") & "th day of " & Format(dteholder, "mmmm") & ", " & Format(dteholder, "yyyy") dteholder is the name of your date field. You'll have to make that change in the expression. The issue is going to be the "th" after the day. The th...

In your query you could set one the TeleNumber to Right(Tele1,7) Then put this function in a module Function CompareNumbers(pholder As String) Dim valholder As String pholder = Right([pholder], 8) Dim x As Integer For x = 1 To Len(pholder) If IsNumeric(Mid(pholder, x, 1)) Then valholder =...

Morgan, have you tried rebooting your machine. That may help. Paul