Search results

Its OK i've sorted it with a union query SELECT * FROM UnionExpDet UNION SELECT * FROM UnionExpMil ORDER BY PeriodID;

I have a db which enables users to enter expenses. tblExpense tblExpenseDet tbleExpenseMileage tblExpenseDet & tblExpenseMileage are joined to tblExpense As the expenses are entered at User Level not Client Level, I need to extract the Client ID from the 2 sub tables to create a list grouped...

Fyi All the fileds referred to are of the same data type thanks

Hi guys Can anyone tell me why im getting a type mismatch error with the code below? And an alternative that works would be a bonus. As u can see im trying to extract a value from a table based on 2 values from my form. Private Sub ProjectId2_AfterUpdate() Dim strFilter1, strFilter2...

I ve searched these forums but cant for the life of me find the answer althought there are a lot of posts on combo box filters. I have MainForm based on tblStaff. I have SubForm based on tblTimesheet. They are linked by StaffID. The user selects a Project from ProjectID in the Subform which...