Search results

I'm afraid that doesn't work... That is now taking Me. [Selected] as being the actual value of the text I am filtering on, rather than the value held in the field called Me.[Selected]. The field is a text entry by the way...

I have a form that normally opens to show all clients. I have another form which lists invoices in a subform. I have made the invoices so that they can be selected and at the bottom I have a field that shows the currently selected client reference. I wish to be able to open the clients form with...

Is it possible to disable the mouse scrollwheel from within Access?

Hopefully, I can now explain clearer how this problem is occuring... My query has a list of uniquely named conditions, of which there are tests linked with a one-to many relationship. When I try to use the count([Condition]) function, the report is giving the total number of tests. When I run...

Thanks GaryPanic. That worked too but I've decided to stick with RG's solution.

I've managed to sort this out myself! I was using the + symbol instead of the & symbol, enforcing 'Null propogation' as it says on the website! I've now changed the second symbol to an & with perfect results! Thanks again for your help. I've added to your rep!

Thanks. That's solved one of the problems. Now there aren't any gaps in the address! I just need to sort out the problem with the house number now. The field for the second line of the address is constructed as [HOUSE_NO]+" "+[ROAD_NAME]. This works fine if both fields have something in them...

Not sure I am! Any chance of an example?

Hello RG, I didn't try to change the address in the query. I was doing it in the field formatting of the report itself. The fields are exactly as they are in the imported table. This is why I asked if there was another way of doing it as I wouldn't know how to do it in sql. Here's a typical...

Yes, that's right. But, I wanted some way of applying these fields to new ones, for example Address1, Address2, ..., as the report is run. Some of these would be conditional so I was hoping to us code to assign the values, hence asking where any code should be, if it's possible. However, if you...

Ok, I seem to be making progress but we're not out of the woods yet...! As my original query was quite complex, I produced a second query based on the first. This has narrowed down the options, but I'm still getting a couple of entries under the same client name, as the query is selecting more...

Thanks for the reply Swillsy! I was using the count([Fieldname]) and that's where it seems to count all occurances. How does the select distinct work?

I have a report that uses group headers to display the results of a query. I group entries that are the same so that it only show a single occurance, but if I do a count of the entries, it includes every occurance. How do I count the unique entries?

I have a report in my database that prints reminder letters for appointments. The client address details are imported from another database with the fields HOUSE_NAME, HOUSE_NO, ROAD_NAME, LOCAL_NAME, COUNTY_NAM, COUNTRY_NA and POSTCODE. However, I wish to work with these so I can produce a...

Ok, here goes... SELECT PATIENT.PAT_ID, PATIENT.TITLE, PATIENT.SURNAME, PATIENT.FORENAME1, PATIENT.FORENAME2, PATIENT.DOB, PATIENT.SEX, PATIENT.MARRIED, PATIENT.NEWNHSNO, PATIENT.REG_GP, PATIENT.USUAL_GP, NEWADD.HOUSE_NAME, NEWADD.HOUSE_NO, NEWADD.ROAD_NAME, NEWADD.LOCAL_NAME, NEWADD.TOWN_NAME...

Hi Rabbie, Thanks for your reply. I've used the advice on that link before and it helped before, but this time there doesn't seem to be anything wrong as far as the criteria are concerned. As I said, it was working perfectly until I added the extra field. Since then, nothing at all is...

In my current project, I have an imported table of Clients that I don't want to alter. Linked in a query, I also have two other tables; One holds addresses for the names, linked by Client Reference and the other holds additional comments, both of which need to be updateable. This was working...

The report must include ALL names, so if I filtered on whether the details were available, the names with no additional details would be left off. As an example, a similar database could hold a list of music CD titles in one table and a list of tracks for all the CDs in another table, linked...

I have a report that is based on a query. The query gives names from one table and many entries for that name from another. I have designed a report so that the name is in the header of the name group and the entries for the name in the detail section. Sometimes, the name has no entries for it...

This appears to have worked. Thank you! There are a couple of tabs which are still not editable, but that's fine as I didn't want them to be. They are just logs of previous events. But now it is possible to amend the main patient data and everything appears to be running smoothly. Thanks...