Search results for query: *

To really do this with any high degree of accuracy is an enormous undertaking. However, there may be a simple solution because your file is in text form when it is transferred. There are a number of commercial software packages available that do this with varying degrees of sophistication...

I know this sounds like a terrible idea, but it would solve a big performance issue for me. Does anyone have any experience or ideas on how to essentially bypass the transaction log when doing updates? My application uses a SQL2000 database as a temporary processing area for a large batch...

Search help for "UNION"

If you want all AND's or all OR's between fields then you could put a radio button control on your form for the user to select AND or OR. Then you build the query both ways, one with AND's the other with OR's and call the appropriate query based on the status of the radio button. If you want to...

I believe that Access has a like operator, but I'm not certain of the syntax. In any case I assume you are saying you can't enter more than 1 criteria per field. If so, progrma your combo boxes to return a string of values such as [IDcombo] = 'abc,def,xyz' where abc, def and xyz are the criteria...

Unless I'm missing something (quite possible), I think you just need to switch your AND's/OR's around: WHERE (((Report.ID)=[Forms]![View/Modify]![IDcombo] OR ([Forms]![View/Modify]![IDcombo]) Is Null) AND ((Report.AddedBy)=[Forms]![View/Modify]![SupporterCB] OR...

"select count(IP) from Web_stat" works fine "select distinct IP from Web_stat" also works but "select count(distinct IP) from Web_stat" doesn't work, giving a syntax error. Try this: 1)Define and save query #1 for distinct IP: "Select Distinct IP from...

Try this: strQ = "select tblEmployees.PhoneNumber, tblEmployees.lname, tblMaster.Buddy, tblEmployees.ACESID, tblEmployees.fname, t2.PhoneNumber, tblEmployees.ACESID, tblInOut.in, tblEmployees.UserName from tblEmployees Left Outer Join tblInOut On tblEmployees.UserName = tblInOut.UserName...

Actually, I think you have solved a different problem than Clyde is asking about. I read his post such that he wants the first and last bottle sold, regardless of type. Your query returns first and last BY type. Maybe that is what he wants, but I've always wrestled with the easiest way to return...