Search results

image of DB Maybe this will help clarify what I'm trying to do. Here is an image of what I'm working with and trying to accomplish.

it kind of works Well, it almost works. I suppose I should have told you that I have other fields (like Price and EndDate) So as soon as any one of the other fields is different then it shows both records. If the item code is the same then I only want to show the item code record with the...

Is there a way to include the "Compact and repair database..." function in a macro? I have a macro that runs a lot of make table and delete queries. Consequently my database "grows" considerably. I'd like to 'compact' the database at the end of the macro. Thanks in advance, Andrew

thanks Thanks! I'll give your suggestion a whirl tomorrow morning. I just caught this before going to bed. As to your question, I use two tricks. 1) Set the font to a proportional font, like "courier new". 2) Instead of using the space-key, use the code of a non-breaking space - i.e. & n b s...

answer Got it! SELECT Table1.item, Table1.date FROM Table1 WHERE (((Left([table1].[item],1))<>'*'));

I have a table with say two fields, Item and EffectiveDate. I will have data as follows. Item   EffectiveDate (mm/dd/yy) One    04/01/2003 (record 1) One    04/04/2003 (record 2) One    04/06/2003 (record 3) One    04/03/2003 (record 4) Two    04/05/2003 (record 5) Two    04/04/2003...

I have a database where the "Item" field sometimes contains item codes with an asterisk as the first character. I want to filter out all item codes that begin with an asterisk, but for the life of me I can't figure out how. Any help will be greatly appreciated. Andrew