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 Chriss Miller 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. powerprinting

    character date to date fields

    I have a field that is character containing dates... Ex: 19991102 I want to convert this to a date field... whats the proper syntak to convert this field to another fields of proper date?
  2. powerprinting

    numeric field

    Thanks Mike, that should work better
  3. powerprinting

    numeric field

    I think I solved my own problem. I used set filter to isblank(payoff)... only blank records are showing. Hopefully this is my best way. Thanks
  4. powerprinting

    numeric field

    I have a numeric field my database. The data is populated with any number from 0 on up. However, sometime the field is blank, containing no numbers at all. What syntak will isolate the blank records. Everything I try to do evalutes the blank record as being a 0. I dont want a 0 in that field...
  5. powerprinting

    10% screen band on reports

    thanks
  6. powerprinting

    10% screen band on reports

    ahhh.. you were right, I didnt select count in calculate field... seems to be fine now.. you have been patient.. thanks. Now I know how to do this...
  7. powerprinting

    10% screen band on reports

    varible = cnt value to store = 0 initial value = 0 calculate = nothing
  8. powerprinting

    10% screen band on reports

    I did... I tied the varible to the BOX... not the data. The shade box in the form I added.. print when mod(cnt,2)=0 however, each line is shaded... not every other one In the BOX is the print when varible
  9. powerprinting

    10% screen band on reports

    Getting closer!!! I removed any refrence to the varible in print when in the data detail. The shade box in the form I added.. print when mod(cnt,2)=0 now, each box is shaded. Not zebra.. I must be missing one addition element.. but dont know what. each line is shaded. I I put mod(cnt,2)=1...
  10. powerprinting

    10% screen band on reports

    yes, Zebra is what I want.... from what you say, I am putting the varible in with the data fields and need only ONE detail line, not two. and the varible needs tied to the box... I hope I understand the correctly.. let me try that. Again thank.
  11. powerprinting

    10% screen band on reports

    Either I am very confused or havent explained well. Here is what I did. first, I set up a variable, used your suggestion and called it cnt. next, I inserted into the detal band two rows containing the same fields names of name, address, city... etc the first band is shaded with screen, so far...
  12. powerprinting

    10% screen band on reports

    ok.... got it working.. almost. My only problem is it is insterting two addition bands with no info in between the correct lines.. make sense?
  13. powerprinting

    10% screen band on reports

    Still working on it... I guess reports arent my stong point.
  14. powerprinting

    10% screen band on reports

    I think I have good start with this. No, the table is indexed, but I could add a field that will populate numbers to creat the look of 1,2,3,4 etc.... In the print when expression, I put print when myfield = even ( or odd ) thats not correct I know.. what would be a correct syntac for that...
  15. powerprinting

    10% screen band on reports

    I know there must be a simple method to adding a 10% screen to every other line in a simple report... but it is slipping my mind how to accomplish this.
  16. powerprinting

    HOW EASILY SPLIT ADDRESSE

    Can a number be a part of a street/road name? Say, 134 56th North Road? I can find no instance of that.. the database is small enough I could catch those later anyway. Still not sure how to write the loop routine though. Although in theory, it looks like what I need to do.
  17. powerprinting

    HOW EASILY SPLIT ADDRESSE

    HERE IS AN EXAMPLE OF THE ADDRESSES IN A FILE I AM WORKING ON............................................ 28829ORCHARD LAKE RD 25717POWER RD 28588NORTHWESTERN HWY 315MELFORD 30560BECK RD .............................................. What command or snippet is most useful for...
  18. powerprinting

    append to table, sql 2000

    No, not changing any structures. This is a good start. What utility is it I use? Query analyzer?
  19. powerprinting

    append to table, sql 2000

    Hope you can help me. We lost an employee who is well versed in sql server 2000. I am assigned the task to rescue a job we have. He set up an web based program for us that incorporates the use of a database containing 8 tables. All the functions work well, the web site runs fine also. My problem...
  20. powerprinting

    about screen Resolution

    that might be an option Brian.. thanks

Part and Inventory Search

Back
Top