Search results

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

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