Recent content by Juliette

Sorted it- thanks. Juliette

Hi I have created an excel sheet with 700 StockCodes. I want to create a table that includes all codes. The first row is headed with the Access field name 'StockCode' but when I copy and paste the table is empty. What am I doing wrong? Thanks Juliette

Hi I have two date columns and have worked out the difference between the dates. Expr1: DateDiff("d",[OrderDueDate],[MLastReceiptDat]) Can someone help how to show the result as a percentage Thanks Juliette

Thanks all sorted now. Cheers Juliette

Below is a snippet of 20,000 records. As you can see the stock code appears numerous time with different dates. I just want to show the earliest date for each stock code. Job StockCode JobDescription Warehouse 000000000100752 10374 SM ASSY:M100X LAMPHEAD SUB 12/05/2015 000000000101382 10374...

How do I do this via Design View. Juliette

Great and thanks for the welcome

Hi I have a table with numerous stock codes which are duplicated because the date raised against them is different. I have been asked to provide the earliest date that a record was created for each stock code. Any idea how to do this. Thanks Juliette

Hi all, not necessarily new to access but I'll definitely be posting questions. I get stuck now and again and trawl through google but never seem to find the answers so hopefully someone here can help. Regards Juliette