Search results

Glad to help!~)

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

thanks mate!~)

if you can not get anything to work, then a work around could be to use .sourceobject to load a subform with all columns when necessary!~)

I'm not quite sure I understand but maybe you need to look at fixed column headings in the cross-tab query?~)

Does this work?~) =IIf([LeaveTypeID]=1 Or IsNull([LeaveTypeID]),0,IIf([MEPNumber]<200,[BasicSalary],[BasicSalary]/30*21))

are you all set!~)

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

Like "*" & forms!YourForm!YourComboBox & "*"

IIf( [LeaveTypeID] =1,0,IIf([MEPNumber]>200,[BasicSalary],[BasicSalary]/30*21))

Well you could change your query1 to: SELECT TBL_All.[SAP Code], TBL_Team.Team, TBL_All.Explanation, TBL_All.Teams FROM TBL_All INNER JOIN TBL_Team ON TBL_All.TeamID = TBL_Team.TeamID WHERE (((TBL_All.Teams) Like "*" & [forms]![FRM_SearchMulti]![frame43] & "*") AND (([sap code] & " " &...

If it's the same table you only need the main form as RainLover also says... If you want the option of entering more then 1 license plate then you take the LicPlate field out of your table and create a new table: tblLicPlate id (auto etc...) idCar (because of course you also have an id in...

I have an example on parodux.com in the section 'gratis' it's called 'Vis billeder i din database' and you are welcome to download and use the code!~)

First open your query in design view and then switch to SQL view. Then change SELECT to SELECT DISTINCT:) ..og forresten hvis du senere skulle faa brug for hjaelp med en database, som kan give dig praecis det du oensker, saa kontakt mig paa parodux.com