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 bkrike 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: amandabf
  • Content: Threads
  • Order by date
  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

    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?
  5. 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...
  6. 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...
  7. 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