Search results for query: *

I have a query based on a set of constraints entered by user in text/combo boxes. However when i run the query i get the following error message Runtime error '3065' cannot execute Query I have run the sql threw the query wizard and it works there but not in the module code **************...

I have an insert statement that doesnt quite work right ************** Dim strSQL As String Dim antpost As Double strSQL = "INSERT INTO shiftcalculations VALUES (1111, " & Me.Ant_PostShift & ", " & Me.sup_infShift & "," & Me.right_leftShift & ")" CurrentDb.Execute strSQL...

HI Im tryign to get the average of five fields, on a report. However the fields are not allways in use so i need the average to adjust to any empty fields. How can this be done eg f1 0.1 f2 f3 0.35 f4 0.65 f5 -0.15 or could be f1 0.1 f2 0.5 f3 -0.26 f4 0.123 f5 0.36 Any idea Cheers Nick

HI im trying to filter a record set in a form and but doesnt seem to like the ApplyFilter function any ideas DoCmd.ApplyFilter , "customer_id = '" & customer_id.Value & "'" Cheers Nick

HI im trying to read in csv file adn then import the data into a table. Everything works so far but before the csv is added i remove the first 6 lines of it except for the first one. How can i get just the ref no and append it to all records in the csv. the ref no looks like ref id: 1234...

Hi Can anyone help im tying to remove the first three lines of an imported csv before i add it to the database. eg name :fred date : 02/05/2003 ref: 1052355 then the fields that i want i need to remove the top three lines automatically bofore the data is added to the table thanks in...