Search:

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

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    547

    Does the sum get calculated in the footer of the...

    Does the sum get calculated in the footer of the subform?

    I just did a test and found that it worked if I put the NZ function in the subform sum.

    =NZ(Sum([Amount]),0)

    John,
    Long time - hope...
  2. Replies
    2
    Views
    407

    Reports have an "HAS DATA" property, which is...

    Reports have an "HAS DATA" property, which is true or false.

    So you should be able test that with an If statement, and either use total from the report, or 0 if the report does not have data....
  3. Replies
    2
    Views
    407

    I have a report that shows details from two...

    I have a report that shows details from two subreports which are based on cross tab queries. Each of the sub-reports has totals calculated on the report. I want to add the two totals together. ...
  4. I have about a dozen smallish (10-40 pages)...

    I have about a dozen smallish (10-40 pages) procedures documents created in Word
    I would like to have these have a Table of Contents and Index as stand alone documents but also have an overall...
  5. I am used to using MSN MoneyCentral Investor...

    I am used to using MSN MoneyCentral Investor Currency Rates.iqy in Excel (Data..Import External Data..Import data).. CAn I do the same in Access
  6. Replies
    1
    Views
    321

    Data Collection via Email (2007)

    Anyone using this have any suggestions of good sites to explain it properly. I am getting errors that dont make sense and a Google and search of Microsoft found no answers
    TIA
    Steve
  7. Replies
    7
    Views
    1,030

    2007 constantly crashing (XP 2003/2007)

    I have an XP machine (all updates installed) with both Office 2003 and Office 2007 installed. 2003 was installed first and has been running fine for years. I have two issues

    Whenever I start...
  8. Update Obsolete Items (2003 All Updates)

    I am missing something or have a blind spot about how to do this

    I have a table (TblAll Products) with all my products in it including a yes/no field to determine if a product is obsolete or not....
  9. Replies
    7
    Views
    442

    Re: Most recent Cost (2003 All Updates)

    Hans/John
    Thanks again. I assumed MAX would come into it somewhere but wasnt sure how- Much appreciated

    John, I am sure I can get this to work with Quick Books but surprisingly the structure is...
  10. Replies
    7
    Views
    442

    Re: Most recent Cost (2003 All Updates)

    Thanks again both of you for your help and interest- I'll give it a shot

    Steve
    PS believe it or not John, its not MYOB for a change but ODBC from Quick Books
  11. Replies
    7
    Views
    442

    Re: Most recent Cost (2003 All Updates)

    Records the full date
  12. Replies
    7
    Views
    442

    Most recent Cost (2003 All Updates)

    I have a table that has records of a series of stock purchases with date and cost of each stock item. As each bill from a supplier is recorded separately in the table, obviously there could be more...
  13. Calculated Field on Sub form (2003 All Updates)

    I have a sub form which has data such as cost and quantity. I want to calculate the total for the individual line so have used the =Form.SubFormname.fieldname process eg multiply the quantity by the...
  14. Replies
    8
    Views
    486

    Re: Opening Stock (2003 All Updates)

    Hans, Thank you for your help
    John (who, by the way Hans, actually has a lot of experience with this particular accounting package) thank you for thinking more laterally than me. After a bit of...
  15. Replies
    8
    Views
    486

    Re: Opening Stock (2003 All Updates)

    Sorry John - had replied to Hans before I saw your note.
    Yes it is MYOB . The go backwards method may work - let me test it. Thanks
    Steve
  16. Replies
    8
    Views
    486

    Re: Opening Stock (2003 All Updates)

    Thanks for the suggestions.
    Sorry Hans, I thought I had explained it properly but I was probably overdoing the detail. I attach a spreadsheet showing some examples.

    Basically I need to start...
  17. Replies
    8
    Views
    486

    Opening Stock (2003 All Updates)

    I use data from an accounting system that has an intriguing way of storing opening stock balances for stock items. Each item has an opening stock balance for each financial year that it existed. ...
  18. Outlook constantly sending (2003 All Updates)

    Outlook is constantly showing it is sending 1 of 1 emails. There is nothing in the outbox and even closing Outlook does not stop it, nor do I get the error on closing while still sending email. I...
  19. Replies
    5
    Views
    428

    Re: Update Query?? (2003 All Updates)

    I am getting "Must use updatable query" - what am I doing wrong.
    I have created an Update Query
    I have the query which finds the unmatched items and the Table I am trying to update linked and am...
  20. Replies
    5
    Views
    428

    Re: Update Query?? (2003 All Updates)

    Hans,
    Like most databases I deal with, I have no control over the original data. This is a particularly bad one where the manufacturer has basically lost control of their numbering system eg they...
  21. Replies
    5
    Views
    428

    Update Query?? (2003 All Updates)

    I have a table of products with a field desigbed to show if a product is active or not. ie still available
    I have a query of products no longer available (based on find unmatched query wizard). ...
  22. Re: Pivot Table Newbie (2003 All Updates)

    Thanks again - I've been experimenting with the linking in Excel and its looking pretty good
    Steve
  23. Re: Pivot Table Newbie (2003 All Updates)

    Thank you both very much for your help.
    As suggested, I have attached a cut down version of the database. The Pivot Table is very close to what I want except for the Total Column after each round...
  24. Pivot Table Newbie (2003 All Updates)

    Edited by HansV to reduce huge screenshot in size.

    I need to analyse income and expenses related to a series of motorbike races. Races can be made at a number of tracks each year and all Income...
  25. Word docs open in Outlook (2003 All Updates)

    Some (but not all) of my word documents now appear to opening in Outlook in that I can see the Normal Outlook toolbars at the top of the screen (with the To.. Cc.. sections etc) and the word document...
Results 1 to 25 of 238
Page 1 of 10 1 2 3 4