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!

  • Congratulations TouchToneTommy 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: *

  1. amandabf

    Custom reports based on date

    I'm using Backup Exec 8 and trying to make a report based on the date. The problem is that the date is saved in the veritas database as a "dosdate". Veritas provides a function to translate the date for reports but you can't use the function in a where claus. I really want to make a...
  2. amandabf

    Merge Replicaiton

    I have a question about how merge replication works. How is the data updated? For example, if you have table A that you are replicating to table B and data has been deleted from A, does it also delete the data on B? Does it reference a primary key to update the data? I can't find adequate...
  3. amandabf

    checking to see if a server is available

    I have a button on a page that sends the user to a different server. I want to write code so that the button checks to see if the server is available. If the server is not available, I want the user to be directed to a nice friendly page that tells them the server is down. I know I need an...
  4. amandabf

    converting db file to asci

    it is a propriatary program called qe
  5. amandabf

    converting db file to asci

    I have a dos database program that stores the data in a db file format. I want to convert it to an asci text format but I don't know how. I was told that there is some dos command that will convert it. Does anyone know how to do this?
  6. amandabf

    reporting a value that isn't in the query

    I've thought about doing that, but I need oranges to be a row because I'm counting more than just how many were sold. Anymore ideas?
  7. amandabf

    reporting a value that isn't in the query

    I'm doing a report that counts (for example) the number of bananas, apples, and oranges sold in a given month. My query is a crosstab query. So, of course, if I didn't sell any oranges the category wouldn't show up on my report at all. How would I make it so my report would say 0 oranges were...
  8. amandabf

    data repeats in report

    It was based on the query! Thank you for putting me on the right track!!!
  9. amandabf

    data repeats in report

    My report is supposed to be 3 pages long. After the 3rd page though, everything repeats (except the heading which is set for only the first page) so my report ends up being 6 pages long. It is the exact information that is repeating, so pages 1 & 4 are the same and so on. I don't know how to...
  10. amandabf

    passing parameters in a report

    I figured it out. I wasn't setting my column headings property. Oops! Thanks for your help, everyone!
  11. amandabf

    passing parameters in a report

    I have a report with many subreports and each query is dependent upon the date range. How do I pass the date parameters between queries. I tried entering the parameters in a form and linking them to my queries. This works for my plain select queries, but not my crosstab queries (which are...

Part and Inventory Search

Back
Top