Search results

Hi, I have this module and I'm trying to tweak it so it can add more columns, but everytime I run it, it's giving me error: Run-time error '2147217900: Invalid SQL statement; expected Delete, Insert, Procedure, Select or Update. Did I miss something? Thanks! Public Sub s_runMe() Dim...

Thanks Bob. I ask the same question myself.

I linked the table from an oracle table. In the data type in access it's indicated as a number. Does that mean it needs to be rewritten in Oracle to represent a date? Is there a way to reformat?

I have a set of data that's formatted "20030306" but when I input a parameter on that column such as >=Date()-180, I get an error that reads ODBC - call failed. [Oracle][ODBC]ORA-00932: inconsistent datatypes: expected number got timestamp (#932). What am I doing wrong? I have oracle client...

I want to write an auto calculation date like >=DateAdd("m",-6, Date()) but the dates are divided out in such columns: cc - century - 20 yy - year - 9 mm - month - 2 dd - day - 4 Is there solution to mimic the >=DateAdd("m",-6, Date()) ? Concatination would not work in this case since...

it does exactly what i want to do. thanks bob!

what is >=date()-180? if I want to write 1 year back from today's date of run or 6 months, what's the best way to write this? i don't want to keep rewriting this everytime I do a run that has a date range for a sales column. thanks.

sorry raskew. i didn't mean to sound unappreciative. :( i'm very greatful for everyone's help. I apologize for being so repetitive. I'm very new to access and heard that vba does a better job than building queries. I used the above but I keep running into problems. Any suggestion...

Thank you JANR and MSAccess. Visual aids are so great for beginners like me. :) Is there another way to rewrite this query to produce faster results?

Hi I have a query that I would like to get it converted to a module or vba but doesn't know how. Can someone help me? SELECT VehicleMiles.CarNum, VehicleMiles.DorDate, VehicleMiles.SpeedoEnd, (SELECT SpeedoEnd FROM VehicleMiles AS Alias WHERE DorDate = (SELECT Max(DorDate) FROM VehicleMiles...

I have a similiar audit trail situation, but my data are so large (999,000) that this query is too slow for me to run. I ran this for over 4 hours and only produced about 1 bar even with an append table query. SELECT VehicleMiles.CarNum, VehicleMiles.DorDate, VehicleMiles.SpeedoEnd, (SELECT...

Thanks Mike!

This is exactly what I want to do. I don't see codes in the form. Are there special codes embedded behind the button "Run Routine"? Thanks.

That looks like what I want. But all these coding is like Greek to me. Do you have a visual in the design view? Thanks.

My purpose for doing this is to find all the corresponding R items for the C unique value and put it in a string format. Can you show me steps to do this or codes to do this? What is a good function to use? Thanks.

I have a set of data below: Example: R Item Num C Item Num 123 569 134 569 145 569 145 456 136 456 234 456 My goal is to concatenate the data so that it looks like (below) in their respective column: C Item Num R Item Num 569 123 |...

It does! Expr1: DLookUp("[Field1]","Table1","[ID]=" & [ID]-1) or Expr1: DLookUp("[Field1]","Table1","[ID]=" & [ID]+1) works. Thank you.

Thanks, Bob.

Bob, It's a workday problem. Is [dteMydate] a function code or a table field name? Thanks.

If I understand correctly, then ... IIF(Weekday(Date()=1,Date()-3)) which means 1=Sunday then take away 3 days to bring back to Thursday?