Search results for query: *

Hi Thanks - that worked. I've sorted it out now as well - only 1 record was corrupt and I've changed it so that it won't happen again. Have a star! Cheers Leigh

Cheers for your reply - Yes I did try this as well (in a round about way) - however (using your example) won't this mean when all the records from 1247 onwards are posted into the new table - their ID will change (it is created by autonumber) as record 1246 no longer exists - so in the new table...

Hello I've got the same problem in my database - one of my records in the company table has become corrupt and is showing these chinese characters. I've tried copying the table and pasting it to get rid of the record but everytime I try to do this, access closes down and says an error has...

I've managed to sort this now thanks, by changing the format of Month:format([Date], "mmm") - for the month name, eg Jan, Feb etc to Month:format([Date], "mmm yy") - for the month name, so it now reads - Jan 02, Feb 03 etc This now orders it correctly - Thanks anyway Leigh

I am having a similar problem to this and found this old message - Basically I want to order some data by months in a chart. The data runs through academic years however, so the months run from for example Sept 2002 to August 2003. I can get the data to appear in the correct order in the query...

If I have understood your query correctly this is similar to something I have done: Create a query with the fields CaseID (from your case table) and NoteDate(from your history table). Then group by max NoteDate (by clicking on the Totals icon at the top) This will find the latest date for each...