Recent content by zeeforel

A ha, now I understand! Takes a bit of work but it is a great suggestion. Thanks very mucht for this!

Yes, I did. But could you please give me a hint how to proceed? I do not have experience running VBA... Thanks.

Thanks for responding so quick! What I mean is this: Field 1: width 6 Field 2: width 12 etc and all fields separated by ";" How can this be done? Many thanks!

Hi to you all! I have a question about exporting a table to a csv file where I need the combination of: a fixed (variable per field) width per field AND a "; " (semicolon) as a delimiter Using Access 2016 is this even possible? Many thanks in advance!

Just to come back to the issue: the solution of indexing the most-searched-on-field was perfect. Search time improved from 5 minutes to 15 seconds. Incredible!! Thanks again.

spikepl, you got me there! Maybe that is a very good idea. Will come back on this. Thanks.

Dear CJ_London, First of all thanks very much for this quick reaction. To answer the questions / respond: 1. Why is splitting no good idea? How do I make sure the individual table (no queries across tables involved!) are properly indexed? All tables have a primary key being some unique...

Dear all out here, Hope you can provide me with some tips for the following issue I am currently facing. I have a Access DB (2010) with 6 tables with each around 1,2 million rows. The size is 1,3GB. The DB contains data that is also loaded (monthly) in some application, but we use the DB for...

I did that exact recipe earlier but then Access seemed to skip the where clauses from both seperate queries... Will try again today.

Hi Plog, Thanks for responding so quickly. At first I did try to combine all querying and filtering in one query but that resulted in strange things and above all was not that transparent. The seperate queries are used to identify loanid's that need to go from a certain portfolio based on...

Dear people out here, I am trying to combine the result of two specific (and different) queries on a set of loans. As a result I have to sets of query results: + result query 1: with first field LoanID and several other fields + result query 2: with first field LoanID and several other fields...

Please find attached a fictious database to simulate the real one. :-) The file contains two tables for the months July and August, each having 4 fields: + ID + Loan ID + LoanPart ID + Balance Beware: the loan id's sometime occur multiple times because actually a loan could consist of more...

Dear pr2-eugin, 1. These are just monthly snapshots I need to analyse. There is nothing "double" in the DB. 2. t and t-1 mean like September and August. 3. Names are just for illustration purposes 4. ??? I really am a newbie on trying to solve this, although I have a small clue about joins...

Dear all, As a Access newbie I am looking into a problem that I hope to solve structurally and "transparently" via Access in stead of Excel. I would like to compare two similar tables for different months. I am looking for: + loan id's that are new in table(t), i.e. not exist in table(t-1) +...

Thanks!! HTH, Thanks very much. I will certainly try this. Marcel