Search results

Hello, I need to know which records sum up to a given value. Lets say I have the following entries in a table: 1 = 78 2 = 56 3 = 120 4 = 24 5 = 480 6 = 89 7 = 489 8 = 98 9 = 54 10 = 569 If I provide to the query the value 752, I need to know which records sum this amount. In this example I...

I am attaching a DB with an example. I have a table with [DateONE] and [DateTWO] fields. In the query I have tried to use the expression Expr: DateDiff("d", [DateONE], [DateTWO]). It does not work. Access does not allow the expression. Please try and give some feedback. Many thanks, Mauro

Access 2003 Help shows the following syntax: DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) Where Interval is yyyy - year m - month d - day Nevertheless it does not work. How would you retrieve the number of days between today "Date()" and a given date...

Access 2003 Help shows the following syntax: Sintaxe DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) Where Interval is Configuração Descrição yyyy Ano q Trimestre m Mês y Dia do ano d Dia w Dia da semana ww Semana h Hora n Minuto s Segundo Nevertheless it...

Bug in Access 2003? Hello I am trying to use the above code in a Query and Access tells me that the syntax is either wrong or something is missing. Do you know anything about this? Thanks, Mauro

Hello, Does any of you know how to make it possible to edit the fields of a form displayed as a dynamic table? If the form is displayed as a data sheet the records can be edited but when the form is displayed as a dynamic table the records CANNOT be edited. Basically I would like to have the...