Search results for query: *

There can be 3 or more dupe lines per "group". And after that "group" of dupes, there will be another set of lines needing the same thing done. This is a sample of how it looks: (and this is all made up data..just trying to show an example) Column A Column B From Date Thru Date 5...

I have an excel spreadsheet. The first two lines are duplicates, except for a FROM DATE. So, 4 columns are the same, but the 5th column (from date column) is different. The 6th column is an empty field (Thru date). It looks like this: Col A Col B Col C Col D From Date Thru Date...

thanks. I tried SkipVought's method: =IF(ISBLANK(A2),D1,A2) And it works pretty good. Thanks for all the advice!

Guess that'll work, too! Thanks!

May have figured it out: =IF(A2="", OFFSET(A2,-1,1,1), A2) If I use the (-1) instead of (1), it seems to work because it has to look at the PREVIOUS data, not the NEXT data which would populate it wrong...

Shoot, format didn't work. Apologies. Basically, flush it all to the right so you have 3 data on the 1st line, 2 pieces of data on the 2nd.... (so Column A has data, then the next row is blank, then data, then 3 blanks, then data, then blank)

Sorry anotherhiggins, didn't see your post until after I posted mine. I tried that and it basically populates the entire Column A with the first value only. If there is a value in Column A, then the next rows should be populated with that preceeding value, until it reaches a DIFFERENT value...

I tried it, but it only returned a value of "0". So I'm still experimenting with it to see what's not working...

I was able to use the OFFSET function, but the only problem with that, is it is populating the wrong data in the next row. If that next row is populated, it can't add data there: Data A Data B Data A Data B Data A Data C Data C Data C So instead of it being Data C with Data C...

I'm looking to figure out how to populate a cel with the previous cel data, IF the current cel is blank. Column A Column B Column C Test A Test A Test A Test A Test A Test B Test B Test B Test B Test B Test B Test B Test B Test B Test C Test C Test C Test C Test C So the empty field under...

That's the error I'm receiving...? Region should be "CO" or whichever the user selects

Sorry...forgot to mention: IssueId is an autonumber Priority, Region, and Status are all strings. There is no "ID" in those lookup tables.

I have a form where the user can select a combo box which will filter the records that are brought back. However, I receive the error: "Run time error 3075 - Syntax error (missing operator) in query expression 'tblissues.issueID is >0 and Region = 'CO"." Here is my code: strSQL = "" strSQL =...

Thanks. The problem I found out, is that both my forms are unbound. So I can't do a "parent - child" link between the two. I'm thinking there has to be something in my query (code wise) that can be written... Right now, the subform is based off a query which links back to a text field on the...

Hey everyone. I have a subform that is based off a query, so I can perform a "keyword" search. The criteria in the query for that particular field is: Like "*" & [forms]![SEARCHfrmGlossary].[txtKeywordSearch] & "*" When I run that form by itself, it's fine. But when I add that form as a...

Hello. I'm using a tab control setup on my Access form. The only problem, is that with 2003, you can't "colorize" the tabs so the user can know exactly which one they are using (if you can, please let me know!). So, I would like to have a text box that displays the name of the tab the user is...

Thanks. I'll have to look into that as well. We are running Access 2003, but we are linking to an Oracle Driver (Microsoft ODBC for Oracle). When I apply a "Group By", that error disappears. So, more research!

Does JetSQL recognize the PrimaryKey of your linked table ? " How would I find this out? The primary key is what is displaying the #DELETE.

I'm waiting on our IT department to get back to me. Upon research on the net and Microsoft, I found this: Microsofts Web Site: "Obtain the latest Microsoft Jet 4.0 service pack that contains an updated version of the Microsoft Jet 4.0 database engine. For additional information about how to...

Ok...seems like it might be a MS Jet 4.0 issue...Guess I have to have IT install the fix...hopefully that works unless someone knows of some other issue it might be...