Search results

So I have a "production table". It has the following fields: ID DATE OIL GAS Each ID has production in different time periods. I need to find the end of each of those time periods and pull the last 3 months of data. >=DateAdd("m",-3,Date()) ... this formula did not work because it used today's...

I am trying to isolate a field with quote marks ("). WHERE (((dbo_AC_ECONOMIC.SECTION)=")); but that does not work.. any ideas please?

I am trying to create a named hierarchy based off a table from an Oil & Gas Program ARIES. The code below is as far as I could get: SELECT dbo_AC_ECONOMIC.PROPNUM , dbo_AC_ECONOMIC.SEQUENCE , dbo_AC_ECONOMIC.SECTION , dbo_AC_ECONOMIC.QUALIFIER ...

I need a field that will rename the " to reflect its keyword. So any word above the " needs to be renamed to the word plus a descending numbering system. For example: KEYWORD OPC/T " " " " " " " OPC/GAS Desired Result KEYWORD OPC/T OPC/T_1 OPC/T_2 OPC/T_3 OPC/T_4 OPC/T_5 OPC/T_6 OPC/T_7...

PROPNUM....SEQUENCE....KEYWORD....EXPRESSION EXAMPLE1....34..............NET.............80..40..40..%..899.395..M$/747 EXAMPLE1....35..............".................72..53..53..%..TO..LIFE Field Definitions PROPNUM = unique ID SEQUENCE = place of code in the program ( reads up to down, left...

I am doing a crosstab query and would like to exclude all the titles with the character * in it. However, access seems to get confused when I type Not Like "*". Thank you, DG

I have written VBA to run a set of queries in a certain order. What remains left is to run without having to drive into the VBA editor? Does anyone have solutions? In word to run VBA you can create a button. I am not sure how it works in Access.

I have created an archive process through VBA but when it is finished I need it to compact and repair. I believe I have the code: Docmd.RunCommand acCmdCompactDatabase. However, the trick is the compact and repair is not for the database it is being ran in. I need to run a C&R on an outside...

So I am pulling data from a SQL data base into access and appending it to certain tables. To do this I have 15ish append queries. Is there a way to have them run in a certain order with one command?

Hello Everyone!, I have two issues: 1. I have a month field with month values and a year field with year values .... I would like to combine them into a date field ex: 8 2012 8/2012 2.The second is a little more complex: There are two fields- the first field is a mixture of positive...

I have entered the function below in the vba module: Public Function ParseText() On Error Resume Next Dim var As Variant var = Split(TextIn, " ", -1) ParseText = var(X) End Function but when I try to execute: ParseText([Expression],1) It replies "Undefined fuction "ParseText' in expression"...