Search results

No worries Clut - all pretty new to me & experiencing a rather steep learning curve at work atm. Was starving before lunch so thought I'd clarify in case I hadn't followed your requirements properly :-) Any chance of a 'Thanks' on that one? (bottom right of my post). Not sure how to mark a...

Immediate IF and Date functions should cover it, no? Like this par example: IIf([task_due_date]>=date(),"Pending","Overdue") AS Expr1 Or were you looking for something more complex?

I have a query producing a large number of records, calculating number manufactured and number sold of each product in inventory. This is based on number of boxes/products/sheets. Some items have not been moved in the month so have no record to pull through to this query so the result produces...

Worked great for me, thanks raskew. Can you confirm whether or not this will work for Bank Holidays as well? Sorry - couldn't figure it out from this :$

Worked great for me, thanks raskew. Can you confirm whether or not this will work for Bank Holidays as well? Sorry - couldn't figure it out from this :$