Search results

Hi, I have a table which holds various time stamps for a booking in process. I'd like to create a query that only picks up a specific timestamp if another timestamp has not been updated For example - 5 15:31 8 15:37 I'd like to only lookup timestamp 8 when timestamp 5 is not in the...

Hi, I need to calculate the number of days between two days however the format on which i have my date includes the time in the same field - 2007-02-20 07:15:30.474 When I calculate one date minus an other the result is #error I require the result to be in a count format e.g 2.3 days (like...

Hi, I've created a report that is based around percentages of returns against despatches. Now I would like to set some conditional formatting on the report whereas if a rates breaks a certain threshold then the font or background colour will be adjusted. Like a traffic light system. I've...

Hi, I am currently using a large Access 2002 database in order to generate various reports. My two main tables are despatches and returns from which they hold around 1,200,000 records and 100,000 records respectively. The problem I have is that the reports use various expressions within...

Hi, Is it possible to change the resulting format of a new field (expression) within a query? I.e. Instead of the resulting when running query being displayed results in decimal places but instead being displayed in percentages Regards

Hi, I'm trying to create an expression that will calculate cumulative monthly totals but my expression seems to only calculate totals for all months e.g Month Direct Despatches Cum Direct Despatches 2006/03 1580 21867 2006/04 10681 21867 2006/05 9606...

Hi, I'm trying to create an expression that will calculate cumulative monthly totals but my expression seems to only calculate totals for all months e.g Month Direct Despatches Cum Direct Despatches 2006/03 1580 21867 2006/04 10681 21867 2006/05 9606...

Hi, I'm trying to create an expression that will calculate cumulative monthly totals but my expression seems to only calculate totals for all months e.g Month Direct Despatches Cum Direct Despatches 2006/03 1580 21867 2006/04 10681 21867 2006/05 9606...

Hi, I'm having trouble trying to create an expression for generating cumulative totals by Month. I believe this is the function I need to use - DSum (expression, domain, [criteria] ) I need the layout to be as follows - Months - Rows Cumulative Monthly Despatches - Column I have a field...