Search results

  1. J

    Query- Group By - Sum - Null Values (need to display 0.0) ....Arghhh

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

    Query- Group By - Sum - Null Values (need to display 0.0) ....Arghhh

    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?
  3. J

    Query- Group By - Sum - Null Values (need to display 0.0) ....Arghhh

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

    Query- Group By - Sum - Null Values (need to display 0.0) ....Arghhh

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

    Making an ACCDE from a Front End... Good Idea?

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

    SUM A FIELD If Another Condtion is met?

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

    Question Central DB with Front End for Users? Advice Please :-)

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

    Question Central DB with Front End for Users? Advice Please :-)

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

    Group by Site - Need Reports on Separate Pages

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

    Group by Site - Need Reports on Separate Pages

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

    Conditional Formatting on YES/NO (True/False)

    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...
Back
Top Bottom