Recent content by jimmy.guilfoyle

Your table name suggests you might have some less than optimum design issues. I agree.... I should know better. Normally the in progress invoices would be in the same table as the finished ones but with a Status field to show their progress. Quotes are usually treated similarly. I work for a...

mmm Perhaps I have misled you as Ive been having a think. I am trying to complete a calculation based upon data within records. I am trying total (SUM) how much money has been invoiced. In my situation there are actually no records i.e no invoicing, so will this NZ function work?

Hi Galaxiom .... Where exactly should I use this expression? In the Query itself? Been messing around creating new expressions referencing fields, searching the www etc... Driving me mad.. Thanks for your advice.... can I have some more :-) Thanks Jimmy

Hi Access Gurus Something is driving me bloody mad… no its not the wife. I have a query whish uses the group by function and sums up based on some invoicing figures (currency) Now my issue is that I need the sum to show a value of 0.00 if indeed there are no records. (from the...

Hi Folks I crated this post here - http://www.access-programmers.co.uk/forums/showthread.php?t=189068 It was ref splitting the DB (front end and backend) This is working well and I'm happy. Is it a good idea to make a ACCDE file from my front end to really restrict what my users can...

Hi Boys n Girls I have tried Access help, Office online, This forum, the web for what Im trying to achieve. Its very simple and yes I cant do it :-( I have a form. On this form I want an expression that will sum if another condition is met. (all data from the same tble/source) I have a field...

Hi Paul, Great advice many thanks for your time. Jimmy

Hi Everyone I’m after some advice on how best achieve something with access 2007 I’ve been using access for a number of years so I have some good experience in using it. (Tables/forms/queries/macros etc) I have to create a central database that I need a number of users to...

K sorted it.... See below On Footer, Select Force Page--> After section Cheers jimmy

Hi Folks I have a report which uses the Group By Function - In design view it Looks like - If I view the report or use print preview it looks like- I have x31 Site IDs (above you can see AT1, and AT3) and if i print the report it will print over 2/3 A4 pages. I need it to print x31...

Hi Folks 1st Post here. Getting back into access again from a few years back and getting to grips with 2007 (yikes) I have been playing with conditional formatting on a report. Here is a snapshot below So in the outstanding field (which comes froma crosstab query) Im ok with...