Search results

Hi Steve , thanks for your answer ; sorry I`m not skilled in SQL. I prefer , if I would , to use the query criteria in MS Access. May be my question wasn`t clear enough. I made a query with this two tables : .Admission , with this fields : Name , Id , Date_Admission. -Events , with fields : Id...

Hello , I need a query that retrieves all records 24hs ahead from de first record . The date added field in my table is in format : 6/5/2017 21:06:00 So,if the first record is in this moment I want only records until tomorrow , 7/5/2017 21:05:00. I tried this : date < [Admission]+1 , but...

Hello , I have a table with date and time fields and need to retrieve the records within 24 hs from de first record. I tried DateAdd (h , 24, [FirstDate] ) with many variants as a criteria in a query and even as VBA code , but doesn't work. Can you help me?

Thank you very much for your answer . I will try it.

Hello, I have a querry with this calculated field : Expr1: DCont("[hta]","Pacientes antecedentes totales","[HTA]='1' ")/DCont("[HTA]","Pacientes antecedentes totales")*100 It is a percentage of value 1 over the total registers with a value for HTA. If I apply a criteria in a diferent field...

Hello sxschech , thanks again for your interest. I think I made a mistake. I create a new DB with a similar structure and code and the reports opens both from the form and directly. Maybe there is something corrupt in the former DB. Sorry for this confusing situation. I'm still interested in...

Thank you very much for your answer. when I open the report directly I'm asked for a value to the field that is in the criteria of the query and it works well. If the report is open from the form ,it is supossed that that the query looks for the value in the same field of the torm ; but it...

Hello ,I need some help with a Report. It is based on a query with this criteria in the field document number: [Forms]![Administrativos3]![Pacientes_Nro de documento] I have a Form with this fields : Pacientes_Nro de documento , edad , sexo , HTA. And many reports named Laboratorio . I try to...

Thank you very much , Alan and Nanscombe. It works!

Hello I'm trying to open a report only if fields age>=50 , gender = male , language = french and type this : If Me.Age >= 50 Then DoCmd.OpenReport " Rpt1", acViewPreview If Me.Gender = Male Then DoCmd.OpenReport "Rpt1", acViewPreview If Me.language= french DoCmd.OpenReport "Rpt1" ...

Hello I'm trying to open a report only if fields age>50 , gender = male , language = french and type this : If Me.Age >= 50 Then DoCmd.OpenReport " Rpt1", acViewPreview If Me.Gender = Male Then DoCmd.OpenReport "Rpt1", acViewPreview If Me.language= french DoCmd.OpenReport "Rpt1" ...

Hello, I'm new in this forum. I work since many years with Access , but in a primary level. So I want to improve my knowledge about MS Access and Visual Basic programming. I search in other forums and was difficult to get the appropiate answers ( maybe because of my inexpertise) , but I like...