A couple of questions, Ms Query, are the expressions the same as with MS Access?
I also need to remove the time element from [JobCreationDate] from the following SQL: ( Forgot to say I want the query to pull data either from two cells [startdate] [enddate] or just the current month.
Code: Select all
SELECT JOB_CONTROL_VIEW.JobID, JOB_CONTROL_VIEW.VehicleReg, JOB_CONTROL_VIEW.VehicleMake, JOB_CONTROL_VIEW.VehicleModel, JOB_CONTROL_VIEW.EstimatorCode, JOB_CONTROL_VIEW.JobCreationDate, JOB_CONTROL_VIEW.JobAmendDate, JOB_CONTROL_VIEW.DiscountParts, JOB_CONTROL_VIEW.DiscountLabour, JOB_CONTROL_VIEW.DiscountMaterials, JOB_CONTROL_VIEW.DiscountSpecialist, JOB_CONTROL_VIEW.DiscountOverall, JOB_CONTROL_VIEW.EstLabourHours, JOB_CONTROL_VIEW.EstLabourNet, JOB_CONTROL_VIEW.EstMaterialNet, JOB_CONTROL_VIEW.EstPartsNet, JOB_CONTROL_VIEW.EstSpecialistNet, JOB_CONTROL_VIEW.EstTotalNet, JOB_CONTROL_VIEW.EstBottomLineDiscAmount, JOB_CONTROL_VIEW.JobStatus, JOB_CONTROL_VIEW.Notification_DateTime, JOB_CONTROL_VIEW.Vehicle_WriteOff, JOB_CONTROL_VIEW.Work_Provider, JOB_CONTROL_VIEW.JobDateOutExpected, JOB_CONTROL_VIEW.JobCurrentLocation, JOB_CONTROL_VIEW.CompletionDate, JOB_CONTROL_VIEW.Insured, JOB_CONTROL_VIEW.CPExplicitStartDate, JOB_CONTROL_VIEW.OrigExpCompDate, JOB_CONTROL_VIEW.ImportedLabourHours, JOB_CONTROL_VIEW.HoursRemaining, JOB_CONTROL_VIEW.EstimatedDate, JOB_CONTROL_VIEW.AuthorisedDate, JOB_CONTROL_VIEW.InProgressDate, JOB_CONTROL_VIEW.InvoicedDate, JOB_CONTROL_VIEW.WriteOffDate, JOB_CONTROL_VIEW.Insurer, JOB_CONTROL_VIEW.JobType, JOB_CONTROL_VIEW.LabourRate, JOB_CONTROL_VIEW.AllocHours, JOB_CONTROL_VIEW.ProdHoursBooked, JOB_CONTROL_VIEW.ActualHoursBooked, JOB_CONTROL_VIEW.Collection_DateTime, JOB_CONTROL_VIEW.Recovery_DateTime, JOB_CONTROL_VIEW.PreBookedDateNoTime, JOB_CONTROL_VIEW.JobDateIn, JOB_CONTROL_VIEW.Estimate_Appointment_DateTime, JOB_CONTROL_VIEW.HandOverDateTime, JOB_CONTROL_VIEW.ReqCompDate, JOB_CONTROL_VIEW.Delivery_DateTime, JOB_CONTROL_VIEW.TotalInvoiceableNet, JOB_CONTROL_VIEW.TotalInvoicedNet, JOB_CONTROL_VIEW.TotalNotInvoicedNet, JOB_CONTROL_VIEW.DaysCurrentStatus, JOB_CONTROL_VIEW.DaysOnSite, JOB_CONTROL_VIEW.DaysInProgress, JOB_CONTROL_VIEW.ClaimHandler, JOB_CONTROL_VIEW.WorkProviderName, JOB_CONTROL_VIEW.CancelledDate, JOB_CONTROL_VIEW.JobExcessDisplay, JOB_CONTROL_VIEW.EstMETHours, JOB_CONTROL_VIEW.EstPanelHours, JOB_CONTROL_VIEW.EstPaintHours, JOB_CONTROL_VIEW.EstAllowHours, JOB_CONTROL_VIEW.repex_code
FROM DBA.JOB_CONTROL_VIEW JOB_CONTROL_VIEW