Recent content by warpathmechanic

I have scoured the internet in search for what I am attempting to do. It is complicated and confusing but I am going to do my best to explain here as I cannot give too much information regarding my company. I have two different database sources that CANNOT talk to each other (For reference we...

I haven't tried it but I certainly will. My biggest problem is the syntax for pulling from two different tables. Other problems include: Pulling the month and year from a field formatted 01/01/1900 in the DSum formula Formatting Currency and the syntax of the formula. I have worked with...

I have searched here and on Google and just about everywhere else but it seems that I cannot solve this problem: I have two tables [Sends] and [Sales Data] One has a date field [Sent Date].[Sends] formatted as "Date/Time" (ex. 01/01/2012) One has Payment Data [Sales Data].[Payment] formatted...

I added the appropriate IF statements and End Ifs and it works like a well greased engine. THANK YOU SO MUCH FOR YOUR HELP!

That fixed it, however now I am getting a Runtime: 94 Error Invalid use of Null regarding this line: inputname = Mid(inputname, InStr(inputname, "/") + 1)

When I tried that, it always gives me invalid reference ParseName in Query

The VBA help is amazing but unfortunately I dont know the first thing about it. Where would I put it and how would I test to make sure it works?

I would but unfortunately the information is coming from an old AS400 table and unless I do a ton of manual work on a daily basis, it turns into a nightmare. As far as the VBA function, is there a way to do it without it by adding another line to your original code Plog? Or at this point does...

That worked GREAT!. My only question is that my supervisor has informed me that there may be a set where 3 "/" are involved for Suffixes: Last/First/Middle/Suffix Smith/John/B/Jr I have this: First Name...

The period is really trivial. Sorry Im new to Access's query arguments. So once I replace the "/", how would I then rearrange the text? Wouldn't having the "/" as a reference point for Left, Right, Mid be easier?

Hello, I have used Hyperion (Brio) to query a databse for several pieces of information. After exporting those to a .csv format and importing them to an access 2007 table I have the following issue: The "Owner" field is formatted as Last/First/Middleinitial Yes this includes the forward...