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

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

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.

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

For example: i have only 1 table tblMainTable -mainID -Date -Wages how do i used this data to query the prev wage and prev date of the next consecutive wage and date? (I want to query the prev.date and prev.wage column to see the pattern in change) . Should i break this data into 2 queries...

Hi I'm new to Access and would like to use the Dlookup to set criteria to look up some data. I heard this is a valueable function. Can someone provide an example, possibility a database uploaded for me to see. I don't understand the sql language. :( Thanks.