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