Search results

total in the visits form is the same issue as total on the report, so it would be: =IIf((Sum([Total Hours Provided])+Sum([Total Minutes Provided])\60)<10,"0"+CStr(Sum([Total Hours Provided])+Sum([Total Minutes Provided])\60),CStr(Sum([Total Hours Provided])+Sum([Total Minutes...

You need to change your recordsource on the report to: SELECT Visits.[Log No:] AS [Visits_Log No], [Crisis Calls Attended].[Client Name:], [Crisis Calls Attended].[Client Address:], Visits.[Total Hours Provided], Visits.[Total Minutes Provided], [Crisis Calls Attended].[Log No:] AS [Crisis...

Here's a screendump from access 2010..

Sounds like you need access 2007 or 2010!~)

so your total on the report would be: =IIf((Sum([Visits]![Total Hours Provided])+Sum([Visits]![Total Minutes Provided])\60)<10,"0"+CStr(Sum([Visits]![Total Hours Provided])+Sum([Visits]![Total Minutes Provided])\60),CStr(Sum([Visits]![Total Hours Provided])+Sum([Visits]![Total Minutes...

If you have 3 textboxes Units, PrizePrUnit and TotalPrize then TotalPrize = Units * PrizePrUnit if you have multiple lines and you want a total then you cannot say sum(TotalPrize), you have to say sum(Units * PrizePrUnit)

you can create 2 queries and change between them by setting the recordsource..

...well you could: Private Sub YourDropdown_GotFocus() Me.YourDropdown.Dropdown End Sub but that might give you other problems (test)... otherwise you are talking setting a global parametre and having code on key up/down/press like if chr(something) then and all that. It seems a bit of a...

In both circumstances you refer to fields in your calculation which has calculations in them. You need the full calculation in your totals field!~)

http://www.parodux.com/?page_id=616

something like: private sub Yourbutton_Click() me.filter = "colA = 5" me.filteron = true end sub

have you looked at database tools\relationships?~)

you press F4 to enter a dropdown field!~)

You have to nest the iif's.. Something like this: MarStatus: IIf([MSt]="Single",0,iif([MSt]="Married",1,iif([MSt] = "Divorced", 2,iif([MSt] = "Widowed",3)))) Syntax not testet!~)

Private Sub Form_Open(Cancel As Integer) Dim rs As Recordset Dim db As Database Dim Project As String Set db = CurrentDb Set rs = db.OpenRecordset("SELECT YourTable.ProjectRef FROM YourTable WHERE (((YourTable.VPrintDate) = Date() - 30) And ((YourTable.Reminder) = 'No')) ORDER BY...

...but why!~)

..you need to link the mainform with the subform via parent/child property on the subform. It will have to be with an id from the car table.

have you tried nz([Floor3]) or iif(isnull([Floor3]),"",[Floor3])

You're welcome!~)

=DSum("[TotaalHectare]";"qryPerceelEigenaar2";"[Eigenaar_id]='" & Formulieren!frmPerceelEigenaar!Klant_id & "' And [Wijzigingsdatum]< #" & Formulieren!frmPerceelEigenaar!Begindatum0 & "# And ([Einddatum]> #" & Formulieren!frmPerceelEigenaar!Einddatum0 & "# OR IsNull([Einddatum]))")