Search results

@theDBguy I did try Nz. Just got errors. I can work with the picking a designated date (12/31/1899 would work). How would I do this?

@The_Doc_Man I know there are times there will be no results. I want to be able to get something back, like with a nz function. That's where I'm stuck.

@theDBguy SELECT Project.IDProject, ProjectInfo.TaskDate FROM Project LEFT JOIN ProjectInfo ON Project.IDProject = ProjectInfo.fkProject WHERE (((ProjectInfo.TaskDate) Between [Forms]![f_Basic]![StartDate] And [Forms]![f_Basic]![EndDate]));

Hi. I have a query based on 2 tables. Table 1: IDProject; Table2: IDProjectInfo, fkProject, fkTask, TaskDate. Left join on table 1 IDProject. I want to use a date range parameter based on a form with user providing the start and end dates: Between [Forms]![f_Basic]![StartDate] And...

@theDBguy thanks. I'm going to try on a simpler report. Maybe there is an issue with the report design

@theDBguy I checked for typos, I've copied the subform control and the text box name from the property sheets. I've also tried the expression builder, but I still get #Error

@theDBguy No luck. I get #Name?

Hi. I keep getting errors when I try to pass the value of a text box on a subreport to the main report. (I'll need this value on another subreport.) Main report is: r_Main Control source of subreport is: Report.r_Main_subA Text box on subreport is: TotalCosts Can anyone help? Thanks.

@pbaldy THANK YOU, it worked! I never would have got there on my own. I appreciate the reminder to change the text box property on the report to rtf.

Hi. I have a concatenated text string that I would like to have part of it in italics, that I can then use that string in a report. String: "First part: " & [FieldA] & ", " & "second part " & [FieldB] Wish: "First part: " & IN ITALICS [FieldA] & ", " & "second part " & [FieldB] END ITALICS I...

@theDBguy THANK YOU, That's exactly what I needed. :)

Hi. I need for format a date+time query field into m/d/yyyy h:nn AM/PM. The format of the property sheet does not hold, so I need to code in the format within the query field. I just can't figure out the syntax. Right now, the seconds are included, which I do not want. The present results, with...

@theDBguy it looks like just what I need. Thanks.

Sorry about that. Sample data: Table1 IDProject , ProjectDate 22 , 7/30/2021 25, 8/1/2021 28, 8/2/20211 Table 2 IDProjectGroup, fkProject, GroupDate 15 , 22, 7/31/2021 16, 22, 8/1/2021 17, 22, 8/2/2021 18 , 25 , 8/2/2021 19 , 28, 8/3/2021 20, 28 , 8/4/2021 21, 28 , 8/7/2021 Wish list...

Hi. I have 2 tables. Table1 IDProject, ProjectDate (this table has only 1 date per IDProject) Table 2 IDProjectGroup, fkProject, GroupDate (this table has 1 or multiple dates, all relating to the IDProject from table 1, but the date in table 2 is not a duplicate of date from table 1) Wish list...

@June7 Thanks.

Hi. I have a continuous subform that includes IDNote, DateNote, TimeNote. There may be just 1 note, or there may be many notes. Is there a way to automatically change the IsGroup field on main form when there are 2 or more notes added to the subform? Or is this a separate update query? And...

Thank you both. I needed an update query anyway, so the 2 query approach works.

Hi. I have a query that I am using to doublecheck and then correct data entry ID IsActual --from table, 0 for no and 1 for yes ActualA --from table ActualB --from table ActualC --from table exp_Actual: IIf([ActualA]>0 Or [ActualB]>0 Or [ActualC]>0,"yes","no") --this is used as part 1 of the...

@Pat Hartman You rock. You are right. No records satisfied both criteria. You got me thinking on the right track. This is how I got it to work. Expr1: IIf([fkPerson]=2, DLookUp("[PersonFullName]","Person","[IDPerson]=" & [fkPerson])) THANK YOU!