Search:

Type: Posts; User: BeginnersLuck; Keyword(s):

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    256

    Access 2010 division by 0 error

    Hi, I have got a div by 0 problem which I've tried to get round by using an IIf statement with no luck. It's in an aggregate query grid, the formula is in "expression" mode and is:
    ...
  2. Replies
    2
    Views
    294

    Conditional statement??

    Hi, I'm not much versed in Excel but would like to do the following task. I have two lists side by side in Excel. In list 1 column a = date, and in adjacent list 2 column L gives the date. There...
  3. Access 2010 - sub-reports - is there a way to hide duplicates on a sub report?

    I have a very complex report which has multiple embedded sub-reports going under differing grouping levels. Hence, if I have a project with an issue there are groupings under Project Headings and...
  4. Hi Wendell - I found the answer in another forum...

    Hi Wendell - I found the answer in another forum for Access 2007 - apparently it was a registry issue on the Commandbar side requiring a deletion of a file accessed via regedit.exe. I backed up...
  5. Access 2010 Report Property box won't click open

    This is driving me insane and it seems to relate to reports which you've initially raised automatically from say, a query or a table - but half way through a complex design for some reason or another...
  6. Thanks Wendell - i got there eventually! :-)

    Thanks Wendell - i got there eventually! :-)
  7. Quick help - Conditional Statement bracketting??

    Hi, I am trying to build a conditional statement which says, If [Project] =1, return the sum of [TimeSpent], else Null , but am knitting parenthesis and commas and can't get it to work.... I've been...
  8. Access 2010 - Bring Forward Dates Selected in Query "Between Dates" into Report

    Hi folks, can you help a relative beginner with her reporting? I've designed a daily report based on a query which selects on one date. Report works great. I have based a seperate report on a...
  9. Thanks folks, I actually managed to find the...

    Thanks folks, I actually managed to find the copy/paste/transpose item and that's managed it fine.
  10. Excel 2010 - Beginner help - dates along horizontal axis rather than vertical.. how can I change?

    Hello folks, hope you don't mind a query for a beginner working in Excel 2010. I have a table in which there are several hundred dates which the person has put along the top horizontal axis, then 5...
Results 1 to 10 of 10