Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ovie52
  • Content: Threads
  • Order by date
  1. ovie52

    only showing the first in a group

    my query results in a situation like this: name letter color keith a blue john b green kate c yellow kate c yellowx i don't want to see the row which has 'yellowx'. I want the query to only show me the first row in a group of rows where 'name' & 'letter' are the same. Can...
  2. ovie52

    link excel cells to text fields in a word mail merge doc

    i have a word mail maerge document with numerous text fields which have been filled in. I want to show thesee in a tabvular format in excel. Can i link the cells?
  3. ovie52

    Simple off-line testing of asp pages

    how can i simply test asp pages on my pc / laptop at home without being connected to the internet?
  4. ovie52

    appending a field to results of a report

    i have a report, the results of which give (typically)10 rows of data. Each row of the result needs to have a 'tag' manually entered on the end. These should all be in the same field. how can i do this. hope someone can help.
  5. ovie52

    TRIMMING FROM A SPECIFIED CHARACTER ONWARDS

    I HAVE ENTRIES IN A FIELD IN A TABLE SUCH AS: 5100V#74853769376 4100#8957984768745 5180#89745967 I WANT TO TRIM THEM FROM THE '#' ONWARDS. I.E. SO THEY READ 5100V 4100 5180 CAN ANYONE HELP?
  6. ovie52

    GLOSSARY OF KEYWORDS FOR USE IN EXPRESSIONS

    where can i access a glossary / dictionary of all the keywords that are usuable within microsoft access queries? I often intuitively know a certain query can be done but it takes hours of trawling through help / web to find the right keywords. I often succeed by using function wizard in excel...
  7. ovie52

    Can I fill blank cells in my table with the value of the cell above?

    I have a table that i have exported into an access database. Many of the cells are blank. I want these cells to have the same value as the nearest non-blank cell above them. e.g. england;london spain;madrid germany;berlin america;newyork ;washington ;dallas would become...
  8. ovie52

    random blank lines appear in my report when exported as a txt

    when i output my report to a .txt file, Access puts in random blank lines. I have read that a remedy is to make the line size divisible by 8 but that still doesn't seem to work . perhaps i'm doing it wrong?
  9. ovie52

    output to text file

    when i output my report to a .txt file, Access puts in random blank lines. I have read that a remedy is to make the line size divisible by 8 but that still doesn't seem to work . perhaps i'm doing it wrong?
  10. ovie52

    Find and replace a character in a query

    how can i interrogate a field in a query for a certain character and have any occurences of this replaced by another character?

Part and Inventory Search

Back
Top