Search results

Thanks. I see it now. Here is my SQL behind the query. I cannot get this to work. SELECT REF_ACT_Expense_Current_Final.Geography, REF_ACT_Expense_Current_Final.BudgetRegion AS Budget_Region, REF_ACT_Expense_Current_Final.Cost_Center_Num AS Cost_Center...

Sorry....I just saw your other question. I know there is a way to toggle to the behind the scenes SQL but I don't remember how to view that. Can I hit SHIFT and somethign to view that?

Is this what you had in mind? I changed the Group By to Where in the query and under Criteria [REF_ACT_Expense_Current_Final]![Region]=[Forms]![Frm_PARAMETER_Metrics]![CboRegion] Thanks, Kurt

I tried that but couldn't get that to work. Here is my coding that opens the report and applied the criteria options from the form. Is there a way of addressing the Where clause you suggest using vba? Private Sub Command126_Click() Dim strCrit1 As String Dim strCrit2 As String Dim strCrit3 As...

Is there a way to ignore fields depending on criteria selected in a form? I want to be able to run a summary query that totals by Category. In addition, I want to be able to select geographic criteria so that the summary query totals for the geographic selections (or consolidated). The problem I...

If I go with option 2....The query name is [ACT_Expense_Summ_01]. The form name is [Frm_PARAMETER_Metrics] and the field on the form is [Cbo_Month_Name]. The approach I took was to name a field on the query "CurrentMonth: =...

I apologize...as I read the opening sentence I realize it is misleading. I have data in two different formats....not forms.

I have data in two forms. Depending on suggestions I receive on how to handle the problem I will describe below I could go either way. The common format between the two is I have GL Transaction detail. Two of these fields are [MonthName] (i.e., "Sept-2015") which was populated based on the...

Pyro!!!!! Thank you very much! The following worked: strCrit17 = "[Term_Date] " If IsNull(Me!Combo132) Then strCrit17 = "([Term_Date] > #1/1/1800# Or Not IsDate([Term_Date]))" Else strCrit17 = "[Term_Date] " & Me!Combo132 & "#" & Me!Text136 & "#" End If I cannot thank you enough for your...

Okay...I think I understand what Spike was suggesting....which is really the approach I had taken in the other strings so I don't know what it was about Start_Date and Term_Date that prompted me to think I needed to do it this way! I think it was because my initial coding wasn't working so I...

Ignoring the strings that combine operators (>, <, etc) and a text field, every other string works if left as null. When I view the Filter in the report it appears as follows: [Function] And [Country_Code] And [Cost_Center] And [Geography] And [Region] And [Budget_Region] And...

Sorry...I didn't answer the suggestion of using an absurd date...which is what I did with the Start_Date and that works fine....but that is because every record has a start date. Only employees designated to be terminated have a term date so this doesn't work in dealing with the Term_Date field...

Thanks Pyro, The problem is I don't know enough about coding to adjust. The coding I do have in place was built through asking questions but not necessarily because I know enough about the coding...if that makes sense. So, varying off of what was suggested to me in the past and therefore the...

I got the Else in the coding of strCrit17 to work but getting the If portion to include all term date records still won't. The strCrit17 = "Not IsDate(" & strCrit17 & ")" results in only those with no dates. I tried the following coding to get it to work but the coding doesn't work. Any...

Point well taken. In the name of figuring these out I went with the defaulted names but you are correct, it does pay to re-name these defaults. I got a little lazy on those that I added to the coding recently. As you can see, I use names for most and then went with defaults. Those with default...

One of my attempts was to handle this in the DoCmd line of the coding. Per the coding below, I did this to handle whether USD or Local Currency amounts were visible or not visible and that worked perfectly. DoCmd.OpenReport " RPT_REVIEW_EE", acViewReport, WhereCondition:=IIf(Me!Combo118 =...

First, thank you for your help. We are getting there. Where my coding only returned results if there was a term date your coding is returnign results only if there is no term date. To answer your question, I need term_date to be ignored as criteria unless a parameter is specifically entered.

I am hoping I can get some help with a date parameter that isn't cooperating. I have a parameter form that feeds a headcount report. Among the various parameter possibilities on the parameter form is a combination box (Combo132) containing operators (>, <, >+, etc) and an unbound text box...

Thank you!

I have a a combobox (Combo118) on a form ([Frm_REVIEW_Parameter]) in which the options are either "U$D" or "LC". I have a report ("RPT_REVIEW_EE") on which I want either the U$D number to be visible or the LC numbers to be visible depending on the selection in Combo118. In the After...