Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PeeweeNo1
  • Order by date
  1. PeeweeNo1

    Data corruption - chinese characters appearing.

    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
  2. PeeweeNo1

    Data corruption - chinese characters appearing.

    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...
  3. PeeweeNo1

    Data corruption - chinese characters appearing.

    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...
  4. PeeweeNo1

    Date order in Chart

    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
  5. PeeweeNo1

    Date order in Chart

    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...
  6. PeeweeNo1

    Only retrieve last history item

    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...

Part and Inventory Search

Back
Top