Search results for query: *

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

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

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

Peping, there are 10 million+ records. At this point I'd like to get them into a table to look at first. nmc9175

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

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

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

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

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

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

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

this is great! thanks for your help tlbroadbent and Yosemite Sam. norman

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

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

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?