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...

That worked! Thanks CJ

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 ...

So I have a simplified my need. I need a query that creates a numbered list of a certain variable. For Example: Field_A....RESULT A B............1 B............2 B............3 B............4 C B............1 B............2 D

Sorry Cronk that was a bad transfer of data. I tried to copy past strait form Access.

This is my stab at the logic. I am just not sure how to put it into Access. A B B B D Look for B ...> (1)if current value does not equal B but the next value does then stays the same. (2)if current value does equals B and the one above does not then the result should be the value above...

So it will be in order from top to bottom. To help you better understand the quote marks note a continuation line in a economics module of a program called ARIES. So if I type the First keyword OPC/T but I would like to continue to another line I put ". For Example...

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...

Thanks guy(s) and or girl!

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.

Cronk, Thank you for the link. How would I implement the address into the vba?

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...

Is it possible to tell the system to compact And repair at certain points in the process?

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?

Killer that works for sure! I created: IIf([FirstOfDelay]=Format([FirstOfDelay],"mm/yyyy"),Format([FirstOfDelay],"mm/yyyy"),Format(DateAdd("m",[FirstOfDelay],[Earliest Production Start Date]),"mm/yyyy")) Which also works but yours is more concise in query editor. Thank you very much DG

Wow, you are absolutely correct! My examples are not doing so hot today. Adding 2 would add 2 months to the date example: 3/2013 Adding 0 would result in no change. Adding 1 would add a month to the date.

Sure, my apologies! Problem 1 Month Field...Year Field...Datefield 01...............2013..........01/2013 Datefield is the desired result Problem 2 Delay Field...Start_Date...Capital_Date -1..............01/2013.......12/2012 2..............01/2013.......02/2013...