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 Rhinorhino 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. 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

    thanks Peping.... re: SQL...I know! Just wished my co. knew... hehehe....
  4. nmc1975

    working with over 2 gigs of data in Visual FoxPro 7

    Peping, there are 10 million+ records. At this point I'd like to get them into a table to look at first. nmc9175
  5. 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...
  6. nmc1975

    Access Menu

    Hi Olifour, not sure how Outlook has it (I don't use it) but a built in menu in Access you could see about designing would be a Switchboard. On the Access toolbar, the switchboard feature is located under 'tools, add-ins, switchboard manager' From there, you could customize functions to put...
  7. nmc1975

    Cummulative totals

    i might not be understanding your question... what are some examples of what your results look like now, and can you show me what it 'should' look like? nmc
  8. nmc1975

    Cummulative totals

    hi Nokaoi, in the query design window, be sure to click on the totals button after you select your criteria and fields, then select total: 'sum' for the field which you want a total for. hope this helps, nmc
  9. nmc1975

    Update Empty Field

    it sounds like you are trying to add records into a table via a query? if so, use an append query instead of an update query. update queries will update existing records, whereas append queries 'add' onto tables with or without records. norm
  10. nmc1975

    Importing data from Excel to Access

    Click on File, Get External data, select file type Excel... After the table has been imported, create an Append Query to add the tables to the existing table. This will not affect the current records in the table, as you're adding records and not updating them. norm
  11. 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...
  12. nmc1975

    select query for only prior month records

    this is great! thanks for your help tlbroadbent and Yosemite Sam. norman
  13. 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
  14. 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...
  15. 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