Search results

  1. T

    Story

    Mushroom growing from
  2. T

    What are some games that you hate to love?

    final fantasy 7... i NEVER completed it... :(
  3. T

    Capitalize all records in a database

    Hey there, I have a database, which is full of data containing lower and uppercase characters. Is there an SQL script i can run to capitalize all letters? The table i am trying to capitalize is called "RQ", and i'm trying to capitalize all data in the table. Thank you in advance...
  4. T

    #error when trying to sum a total

    .... my bad! Really sorry about that, thanks for your help David! You must get sick of people like me.
  5. T

    #error when trying to sum a total

    I'm confused.. You said i should have it on the page footer, and i do have it on the page footer? What have i done wrong? Where should this formula be?
  6. T

    #error when trying to sum a total

    I have put the total formula in the report footer.
  7. T

    #error when trying to sum a total

    Hey there, There are ALOT of threads on this topic, and i've spent the last hour reading them and trying out different things, however i'm STILL stuck. In a nutshell... I have a table consisting of 4 records, each record having a £ value. When i run the report, in the footer, i want each...
  8. T

    Has NASA found (potentially) extraterrestrial life?

    i think people should be allowed to believe whatever THEY want to believe. If it brings that person inner peace and happiness, then who are we to question it?
  9. T

    Has NASA found (potentially) extraterrestrial life?

    I agree with Mike. You'd have to be pretty narrow minded to totally disregard any possibility of other life.
  10. T

    Creating a Chart on two columns of data

    Have just resolved this myself. Issue: i was highlighting Column 1 (months of year), Column 2 (figures for local sales) and column 3 (figures for national sales). I was also highlighting headers for Column 2 and Column 3, and have realised that if i DON'T select the headers, the graph works...
  11. T

    Creating a Chart on two columns of data

    Hey there, I have two columns of data, which i want to create a comparitive line chart from. Column 1 - Local Sales Column 2 - National Sales Both columns contain 12 rows, consisting of numerical values for the 12 months of the year. When i try to run a chart for this data, it will...
  12. T

    Copy data from one form to another

    Hey there, I have two data entry forms. One is called SR, and the other DRF. SR is an ad-hoc job log. DRF is a projects log. When i enter an ad-hoc job, it may end up becoming a DRF. Instead of having to complete the information again in the DRF form, is there a macro, sql script or other...
  13. T

    combine autonumber & text

    I just tried it with a new form, and it seems to have worked, not quite sure why it wouldn't have worked with my old form though... i set them up exactly the same... nevermind, thanks for your help!
  14. T

    combine autonumber & text

    Just tried that, and it didn't work. Thanks for your help though. I'd like to use a query but i'm not sure how and what to do. Thanks for your help so far, if you could possibly break it down for me, that would be a great help! :)
  15. T

    combine autonumber & text

    I'm not actually using any queries to display the AutoNumber on the form. That is incrementally naturally from the settings in the Table Setup. I've uploaded a picture to show you how i've got the field set up, can you tell me what i'm doing wrong? Thank you so much...
  16. T

    combine autonumber & text

    Because i require the unique reference number to contain both text and an incrementing number. This is not uncommon, invoices/receipts and credits all have the same functionality, i'm just not sure how to do it.
  17. T

    combine autonumber & text

    Hi there, I want each record to begin with SR100, and then the autonumber add the incremented number to it. For example: SR1001 SR1002 SR1003 ... ... ... SR10050 Is this possible to do? Thank you! Tom
Back
Top Bottom