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 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: *

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

    Problems with arrays

    I Have a table with the following fields: (in PIPE delimited test) EPIC |NDC |Brand |Generic |Price |FIELD006 3697646|378061401| | | |Tot $: 5.52 3697646|378061401| | | |Tot Vol: 1 3697646|378061401| | |Curr $: 5.52|...
  2. Pharmer

    Want to substitute a blank field ditto?

    I am importing an Excel spreadsheet (from ASCII) where every "record" incorporates 5 lines. This results in a table where there is a 1 lines with a desciption including an item number followed by 5 line where that field is empty. Where table is open, I "shift-control-z" (find and...
  3. Pharmer

    Query "not" statements ignored.

    I am running this query: Query ANSWER: :PRIV:ANSWER.DB T_Data_0507_ASC.DB | ID | Station | | CALC COUNT | Check CALC OPEN as PHARMACY HOURS | | CALC COUNT | Check CALC CLOSED as PHARMACY HOURS | |...
  4. Pharmer

    Can you use Julian date to reference days of week?

    Is there a way to write a query so create a calc field with the day of day, based in Julian dates. I can set P7 to display windows long-date ("Monday, November 21, 2005"), but QBE won't allow "Monday.." Or is there a better way?
  5. Pharmer

    How do I change a charactor in a string to another charactor

    Greetings I have a project where I import large ASCII files with many fields, 1 of which is an account number. The application which generates the ASCII file allows some duplicate named records with the same acct number, replacing the last charactor with a letter based on the its value (A=0...
  6. Pharmer

    How do I convert a query with calc fields to TCursor type?

    I am querying a rather large DB file with a series of queries, the first 2 of which have "calc count" fields. It runs very long (210 seconds). The query is coded as follows: Query ANSWER: :work:withdawn.DB pyx6002.DB | Station | PaType | GenMedName | Amt | Month | Index |...
  7. Pharmer

    How do I query blank fields (to restructure a table to eliminate them)

    I have been importing a text file which yields a table with 64 fields. Many of these fields are blank, and I can change the source generator to eliminate these fields, but I need to find which fields are absolutely blank so that I can redo the source material & restructure the resulting table...
  8. Pharmer

    Ask a query where answer is < a certain time ,>a different time.

    I am managing a project where have to find out the number of occurances of an activity during our non-business hours. I am using imported text where one field list the times of occurences in 24hr time. The range is 00:00:01 to 23:59:59. The operational hours are 07:00 to 18:00. I can query all...

Part and Inventory Search

Back
Top