Search results for query: *

'Is there anyway to make the report group by record without having to sort the record by ascending or descending?' No, is the answer to that part. Will try to work on answer to solve problem in morning if no one else manages to help you.

Sorry, was rather busy when I replied and did not totaly think the question through. Yes I have Grouped on all fields not just the postcode and next of kin. I think my memory is going. Matthew PS Good luck with your endevours.

My method to solve the same problem with siblings in the college is to 'Invoke the query builder on a table' then view totals and 'group by' on the fields which would be the same, tend to pick postcode and next of kin fields. The result being that Amy and Jane Smith, get one letter posted to...

Do you still want help with this report problem? If you send a copy of your db with what you have so far I would happily take a look. I think you need to look at 'Sorting and Grouping' and not use the report and page headers, also I get the feeling you are forcing new pages before or after...

Do you mean an Crosstab Query. If so how many row headings would you like? You could send a db with your table in and I will knock one up for you. Matthew

I have a simple callander form that does not use ActiveX Calander. Let us now your email address and I will mail it to you. Matthew

'This Code Disables the Shift Key Public Sub DisableByPassKeyProperty() On Error GoTo ErrorHanderling Const ErrorNumber = 3367 Dim db As Database Dim prp As Property Set db = CurrentDb Set prp = db.CreateProperty("AllowByPassKey", dbBoolean, False) db.Properties.Append prp MsgBox...

Try changing the Data Type in the underlying table to memo rather than Txt. You will then not be limitted to 256 charachters more like 56000.