Search results

I have a query setup which holds all the mailmerge data. I then have a link to the mailmerge templete which succesfully drops in the appropriate record on request from the user (when the data is not protected). However as it is 'word' requesting the data from access, it doesn't seem to...

Dear Guru, I have an issue which having read some previous threads may not be resolved simply. My database is password protected. The password (presumably) is preventing the mailmerge from connecting the deata with the template. There is not even a password request shown. Is there any way...

HI hope you can help me! I'm wanting to create drop down lists that are filtered as a result of a previous field, but not having much luck! I've tried using a query to do this, but not having any luck! am i going down the right path? Do i need a new query for each list, or can they all run...

Hi there from Sunny Hull. Im having trouble using a DCount to count the number of records in the table that are LIVE or CLOSED and by each Region (eg North, South, East, West) If i use a simple =count(*) to count the total no. of records per region, it is working fine. But when i turn this...

When running a query i have created an expression which is simply 2 fields joined together. JOBLOC:[JOB]&[LOCATION]. I want to link this expression with a field in a second table [SCOPE], but for the life of me can't remember how i did it. Either in query design or SQL. Thanks for your help!