Search results

Q: Are you looking to exclude time stamp 5 (15:31) and all time stamps less than that, or only that time stamp, (or are you looking to INCLUDE all time stamps greater than 5 (15:31)? If there is a timestamp for record 8 then I want the query to pick this up otherwise pick up timestamp number 5...

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...

Expr1: [Qry_AllRepairs_TAT_KN_Front]![Received at rep]-[Qry_AllRepairs_TAT_KN_Front]![Recieved at KN] Received at Rep Recieved at KN 2006-11-21 00:00:00.0 2006-11-21 16:44:06.602 that calc is used to subtract one from another

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...

I do not have indexes setup on a few of the main fields i use to generate queries (I did not build the database!) What are the possible implications of changing these fields to 'Yes (Duplicates OK)' where there are so many records within the table and the database is on a server?

No luck. Any other ideas guys?

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...

Thanks Ken

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

Thanks a lot for that. The expression now works perfectly. You'll have to excuse my ignorance when it comes to Access, but what do you mean by subquery and outer table/query? Also, would it be possible for you to explain why you used certain part of the 'criteria' section of the expression?! :)

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...