Search results

Hi All, About 2 months ago I posted the following [See below] in an attempt to resolve a #Div/0! error relating to my report. I have still not managed to find a solution as no matter how I typed in the expression I kept getting syntax error messages. Having tried all of the numerous...

Hi, I am trying to get calculated fields in my report to work but zero values in the data are throwing up #Div/0! and #Error! and #Num! The main data fields I am trying to work with are: VehicleReading PreviousReading VehicleLitres My aim is to track mileage and consumption for a fleet of...

RUNNING DIFFERENCE PROBLEM: I am an amateur Access user and trying to get a running difference into a query based on a simple vehicle table and a vehicle readings table. This query for a report which will show the daily difference in the odometer readings. The table lists multiple vehicles in a...

I would like to create a pop-up reminder whenever I mark an record Billable ([Yes/No Field]) in my WorkDetail table. In the pop-up I want to enter a date for the next Billing date [for clients who are charged a monthly management fee so that this cannot be overlooked each and every month]. I...

I have tried to change the colour of the text in time fields with no a value of 0:00 by using conditional formatting - to no avail. Is there anyone who can help with this?

Hi I am new to this forum and introducing myself as an amateur Access user. However I have been creating Access databases since 2006! With no programming training I am limited but have found Access to be an amazing tool for everyday business processes.