Recent content by Cosmonaut_99

I'm trying to create a temp table, which is populated by a string, (taken from a recordset). My problem is incorporating the String into the SQL statment, and making it work, What I'm trying to do is to create a temp table, and populate it with the first record of the recordset, (which is an...

Thanks - that explains why I couldn't get it to work. I'll use the recordset suggestion.

Hi, Please see attached a lite version of what I am trying to do. In essence Table "Lag 1 EMEA Forecasts" is populated from 12 separate ODBC source tables connected to the database - in the Lite version there are no ODBC links.. as this works fine already. I then want to use today's date...

Thanks - I've now tried that change, but when I run the code, I now get a 424 (Object Required) error - on that line of the code.

Hi, I'm trying to run an if statment, on the records in a field (called "Current_Month"), in an existing table called ""Current_Months_Lag1_Data". The IF statements work fine - and simply perform a different action for different data in "Current_Month". I am having problems referring to...

Thanks. I've amended the DBS declaration, and a few other issues I've spotted. However, I am still getting run time errors - this time '3141' errors, stating "the Select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect"...

Thanks JHB. I've removed the unnecessary ".Quantity"s, added an "]" for "[GRP_DLVRY]". The "#" in Item# - comes from a system table field taken from a pass-through query, (hence not there by my choice). Here's the revised code. I am still getting Run-Time 424 errors "Object Required"...

Hi, I'm trying to replace an Append query - which is pretty slow to run. The query appends data from fields 2 tables (based on a JOIN between the 2 tables) into a 3rd table. To achieve this, the query needs to review all records on Table 2, and find matches in Table 1. (After reading...

Hi, Thanks for that. I copied your new code into a new module, and tried to run it. However, I got the error message "The Expression you entered has a function name that Microsoft Access cannot find." I had read somewhere that VBA can't handle the term Null or Is Null... hence I went down...

Thanks for pointing this out. I'm working with some EDI interface files- which are sent between 2 sites. Site 1 sends an interfaced message (when a shipment is despatched). When the shipment arrives at Site 2, a new interface message is sent back to Site 1 confirming receipt of the shipment...

Hi, I have a table called "CRP_Match_Master", where one of the fields called "861_Reference" contains some null entries. I want to use VBA to display the table records on a form, where "861_Reference" has Null entries. I have tried to achieve this using a DAO recordset, where the recordset...

Hmm I was simply trying to apply your suggestion to fill the gap. Maybe it's back to the drawing board, with a different method all together. The attached image shows what I'm trying to achieve - e.g. a running total of [MAX 12 MONTHS DMD VALUE]. C99

Thanks Plog ! This is where I got stuck before. I tried to add in an extra field to my table called [Extra_Field], and updated all row values to 1. (The thinking behind this is that this would produce 1 level of running values, rather than lots of sub-total levels). e.g. Cumulitive...

Thanks Mahenkj2. This is one of the examples I had already found on the net & tried, but it proved unsuccessful. Both examples on the page include extra, unnecessary sub-totals or break-downs which complicate the expression, and are not what I want. All I'm looking for is an expression on...

Hi, I have a very simple table called "ABC Analysis Table_02", with 2 fields [Item] and [Max 12 Months Dmd Value]. The table is sorted by [Max 12 Months Dmd Value], descending. I want to create a query using DSUM to calculate a cumulitive running total on field [Max 12 Months Dmd Value]...