Search results

Morning all! Yes, I'm afraid it's me again although I have been away for an encouraging length of time haven't I? :) Got what I suspect is a simple question of syntax so I'm hoping a kind soul will be able to point out the correct notation for my command and away I'll go..... What I'm trying...

Hi guys, I've got two queries, one for a Peugeot franchise and one for a Citroen franchise. Apart from the table name they are the same query. But can I merge the two queries into one for a graph of grand totals? Nope! Anyone got any ideas? The two queries are listed below and I basically want...

Hi guys, I've got (yet another) weird error on my inherited database. I have a form with the standard navigation buttons in the footer (first record, prev record, next record, last record & new record). When using these to navigate to record 3816 there is no error. However when using a few VBA...

Hi guys, me again... Help! It seems that I've managed to break another Access command in splitting my database. Essentially I have a form with several subforms and a button that fires off a command from VBA along the lines of OpenCall_OnHold.Requery etc for each of the subforms. The idea is...

Hi guys and gals, Got a weird problem so really hoping someone has seen this before and can lend a hand :) I have recently split a database into a front end and a back end for multi-user reasons. In the front end the database contains all the code of the back end but none of the data...

Hi guys, Can anyone help with how I should be constructing this query please? I have this so far: SELECT Format(A.Date_Logged,"yyyy" & " mm " & "dd") AS DateRange, A.Action as Action, Count(*) AS Total FROM tbl_security_request as A left join tbl_security_request_track_amend as B on...