Search results

Ok, i'm not entirely sure that what i'm about to ask is possible, but here goes. there are 2 tables CLIENT & LOAN which are linked by a junction table. A person can only appear once in the client table but any given number of times in the loan table. i'm ultimatley trying to write a query...

Hey y'all, I have a form which has our clients contact details (phone, mobile, etc) up the top and then a subform in datasheet view where all the interactions with the clients are logged. The first 3 fields are lookups (no probs there) but the 4 field is a memo field which can often have...

Ok, apologies if I don't explain this as clearly as I possibly should. The background to this problem relates to 2 tables which I shall creatively call 'x' and 'y'. Yesterday, I renamed table X to be called Z and table Y was renamed X. (table y was an updated via cutnpaste version of the old...

Ok so, attempting to write a query for a mail merge... in my table i'm running it off i have a field for salutation/title, one for first name and one for surname...with ones later on for mailing address (street address, suburb, postcode/zipcode) i've worked out how to do the query where it...