Recent content by thenoisydrum

Thanks to you all of you for your replies

Sorry for the rubbish thread title but I couldn't what else to call it. I am appending to an empty table customer name, brand and then sales. So, 3 columns. I have 4 brands in total. Some customers do not buy all of the 4 brands but I need to display the 4 brands, later in a SELECT query. For...

Thanks for your help - I have just spotted a back up which I can open successfully so will use this version

Hi everybody, I have found a lot of stuff online about this but not a solution to it preventing a database from opening In the properties, I seem to have the same permissions as my other databases. The database contains one table and a few append to queries that are based on a crosstab query I...

It's in File>Preferences...... Cheers Andrew

Ok thanks, can anybody else help please?

Thanks Minty but I cannot see how to get to these options?

Hello everyone, I have been using PG Admin 3 to run SQL queries and then exporting the results as pipe delimited text files. I'm now using PG Admin 4 (through no choice of my own) and the layout is very different. I can only see how to export my queries as a csv. When I say export, I mean...

It worked!! I love you!!

Oh I see, I will try again - thank you

Not sure what I'm doing wrong here. This is my table; .... here is the error that I get; What am I doing wrong here? Thanks in advance Drum

Thanks for your response. Do I literally copy and paste your code into a macro, changing the table and field names?

Hi all, I have found a handful of instances on the web where people have asked about this and I even found what appears to be a solution at https://sfmagazine.com/post-entry/october-2015-access-fill-down/ However I cannot get it to work........ This is an example of my data; Does anybody...

Thanks to everybody for their help with this one. I had to abandon the project in the end and have only just been able to come back and reply. All the best 'Drum

This is for audit purposes so I need to show that I have randomly selected the invoices with no intervention