Recent content by stankraj

not sure why, but its giving me an error when trying to close out the edited statement now.. Decode = Decode & DLookup("[Decodes].[CodeName]", "DataDump", "CodeNumber = " & Trim(strCode(i)) & _ " AND [Decodes].[CodeName] = ' & strDecodeSet & "'") gives me compile error: expected...

I get this information automatically sent to me in this format. The actual oracle tables that hold this data are normalized, but they concat the multi value fields into a single column.. its a nightmare to decode since some codes are letters some are number.. just more annoying that the replace...

yes that is what I mean.. its odd though.. for 2-5 it pulls the MV1 data, but for 1 it pulls MV13.. its very strange that only 1 go around would pull different data than the rest unfortunately adding another column wouldn't work as I am trying to decode multiple fields eventually, just wanted...

is it possible to add a 2nd condition onto this? I need Decodes table to only pull codename=MV1 codenumbers back.. the problem with decodes table is it has MV1 through MV13 (13 sets) of codes, each with different meanings. Right now, if I run what you put together.. for some very odd reason...

Hi All, I'm new to this board and have a question about a function that might be easier in VB than straight ms access query writing. The problem I am having is that I have a field that contains numbers separated by commas, these are coded fields which relate to another table with the decoded...