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 derfloh 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: nmc1975
  • Content: Threads
  • Order by date
  1. nmc1975

    how do i flag every 10th record in a table?

    Hi, hope someone out there can help me. I'm trying to flag a yes/no column with a "yes" on every ten records in a large table. How do I do this through an update query? Your help is appreciated, norm
  2. nmc1975

    Hi, how could I separate the data f

    Hi, how could I separate the data from this free field name field into three fields for first, middle, last names? Example of data: DOE, JOHN JAMES Need: Fname: JOHN, Mname: James, Lname: DOE
  3. nmc1975

    working with over 2 gigs of data in Visual FoxPro 7

    Hello, I am working with over 2 gigs of data in Visual FoxPro 7 which has caused it to crash. Any suggestions as to how I can use FoxPro to process this data despite this limitation? Is there a way I can partition the data and have FoxPro know where to look for it and use it? Any advice is...
  4. nmc1975

    Converting weekend date to weekday date

    Hi, I would like to run an update query in Access to update a column called "NewDate" with the following Monday date, if the Date column shows Saturday or Sunday. Example: if Date = Weekend date, then update NewDate to the following Monday date What should I enter as my expression...
  5. nmc1975

    select query for only prior month records

    hi, how do I set my query criteria in a date field to select only records for prior month data? for example: it is november 5th today, and I want only records from oct.01 through oct. 31st? thanks in advance, norman
  6. nmc1975

    Hi, this is a MS Access 97 question

    Hi, this is a MS Access 97 question dealing with macros. I've got a macro updating a field with data from the previous row. Problem is, how do I have this macro keep running until the end of the table? (There are lots of records.) I don't know much about VBA, but I'm thinking maybe I might...
  7. nmc1975

    Auto-run Access

    I want to know how to have Access 97 run by itself each morning at 3am to run some macros I've set up so that my reports are ready when I come in at 8am. Can anybody help?

Part and Inventory Search

Back
Top