Search results

. I've loved technology all my life but I see little point in mindlessly chasing the latest trend. I'd happily trade the shiny new features for a solid productivity boost. On a separate note, I guess the Access feature I'd be most happy with now is a Rise/Removal of the 2GB limit.

I think that this is a key point and one that often gets overlooked by ‘management’. I work in the Commercial Real Estate Industry and we’re a bunch who are notoriously slow to adapt to changing forces. Part of the problem is that it’s so relationship based (here in Adelaide anyway), that people...

Y’know I’m constantly adding new skills and learning new things, but now that I’m in my forties I realise that I don’t have enough time to get good at all the things that take my interest. At the moment I’m juggling new learning experiences like Adobe Illustrator, Statistics, Data Analytics...

I'm just about turning the corner with my Access abilities. It's been a couple of years on and off and I'm now pretty comfortable getting things done from within the GUI. - VBA & Raw SQL is another matter. But with all this time invested in Access I'm now worried that Microsoft is going to...

Boom! Thank you. This is what I wanted to do. Linking the tables together. Eureka!:)

I’m at the stage where I need to reach out to ask for some guidance into - what is likely to be - a fairly simple problem. I have a financial Accounting System which can output data in a specific format. I want to take that data, clean it up a bit and append it to an existing Access DB – Using...

arnelgp, This solved the issue perfectly. Thank you so much :)

Thanks JHB, but this didn't solve my issue. I require both of these statements (and in the correct order) in order to successfully attach a document to the first record. As you know, my problem starts once I try to move on to the next record.

I've been trying for days to write a procedure to attach a simple file to an existing table. The code for creating the temp table is working and the data has been pulled in using a SQL command. The third subroutine creates two recordset entities and I then want to loop through the parent...

This query gives the results that i'm looking for, but takes upwards of 20mins to run. My original table with duplicates had over 140,000 records. Now I have whittled it down to just over 30,000. :)

I got it working. Thank you so much for your assistance. I took your advice and got the subquery working before transplanting it back into the main query. my code was: SELECT [Business Data_TEST].ID, [Business Data_TEST].[Company Name], [Business Data_TEST].[Keep?] FROM [Business Data_TEST]...

Thanks for the reply. I've had a go at this but get a 'syntax error in query expression' error message, specifically at the sub query part. Anyway, heres my latest attempt: SELECT [Business Data_TEST].ID, [Business Data_TEST].[Company Name], [Business Data_TEST].[zip/postal code], [Business...

I had a look at another thread on this forum and made some changes, this is my latest attempt: SELECT [Business Data_TEST].[ID], [Business Data_TEST].[Company Name], [Business Data_TEST].[zip/postal code],[Business Data_TEST].[Keep?] FROM [Business Data_TEST] WHERE ID <> (SELECT Min(ID) FROM...

Tearing my hair out here! I have a table with over 100k records. Many of these records have multiple duplicates, but all have a unique primary key. I'm trying to write a query in Access SQL, where only the record with the lowest primary key value for each record will display. From there I can...

So, I’ve been trying my hand at subqueries, but I’m running into issues with what is effectively a 3 layer query. The scenario is that I have some customers who I would like to (snail) mail flyers and other direct marketing materials. To assist with later analytics I want to be able to record...

It's so simple when you have the solution!! I can see that access did not generate the correct expression in the SELECT statement. By subtracting the Sum of Receipts instead of just Receipts it has solved my issue. I noticed that the expression was duplicated in the GROUP BY Statement, which...

Sneuberg, Nailed it! :) I will digest this now and report back. Many thx

just in case you hadn't had enough of my issues, I have posted my latest issue with this in the query section. http://www.access-programmers.co.uk/forums/showthread.php?p=1504719#post1504719 Thanks for the suggestions so far

I’m trying to get an invoice/receipt payment allocation system built up in my Commercial Real Estate Database. Because I need to bring together Invoice records and receipt records within the same recordset I’ve decided to go down the route of creating a temp table in VBA/SQL and populating the...

Yes I have done this. And it has saved me a couple of times already. Thanks for the tip. Its quite difficult to learn the first programming language. I read alot before even writing my first sub. Initially I thought that I had wasted my time as I still didn't get it when actually writing stuff...