Search results

Hello all I need a little help with a query please. I have a report based on a query which has some calculated fields. Subtotal: ([journey_price]/100*90) is an expression in the query which deducts 10% off of the journey price. This is then used for other calculations. What I need to do is...

Hello all Could someone please help me with the following: Table 1 = Contacts Relevant fields = First Name, Last Name and ID Table 2 = All Jobs Relevant fields = driver_id I have a form with an unbound text box and want to display in this text box the first name and last name from the...

Hello I have the following query running from a MySql database and need a little help please. I need to return a 0 or just blank field if FROM_UNIXTIME(datetime2,'%d/%m/%y %T') is blank, could anyone please help me with modify the statement please? SELECT names, phone, returntrip, cprice...

Hi I have a button on a form which runs a query, exports the data to csv and then opens that file in excel for checking. This is my code which works great: Private Sub RunStatements_Click() DoCmd.TransferText acExportDelim, , "StatementReport", "G:\jobs.csv", True Call Shell("""C:\Program...

Hello Could anyone help me with this issue please. I have been searching for 2 days for a solution that works for me but have yet to find one, and I have looked at cascading combo boxes too but I just can't seem to get it to work. I have an unbound combo box (cboGoToCustomer) on my main form...