Search results

If I will use dlookup function just to find and display 1 specific record, it showing up in a second. So I was thinking if I will choose to show only Top 100 in my SQL string should be quicker but it's not. Any idea ? Thanks for helping. Sent from my SM-T800 using Tapatalk

I have chosen primary key indexed in that table by ORDER_NUMBER as all tables have that number Sent from my SM-T800 using Tapatalk

How can I check this ? Sent from my SM-T800 using Tapatalk

Yes, I hope so Sent from my SM-T800 using Tapatalk

SELECT SALES_ORDER.ORDER_NUMBER, SALES_ORDER.ORDER_DATE, SALES_ORDER.NAME, SALES_ORDER.GLOBAL_DETAILS, SOP_ITEM.DESCRIPTION, SALES_ORDER.DESPATCH_STATUS FROM SALES_ORDER INNER JOIN SOP_ITEM ON SALES_ORDER.ORDER_NUMBER = SOP_ITEM.ORDER_NUMBER ORDER BY SALES_ORDER.ORDER_DATE DESC; * But even...

I'm running my query from linked table from sage SALES_ORDER but it takes very long to show result. Even if I want to see only last 100 records or records from last 2 weeks. Is there any way to load and show results quicker ? Can anybody help me with this problem? Thank you.

I'm looking for template that I could use for employee work schedule. I'm using excel at the moment but I would like to do this in access. Top header in excel I have weeks number 1-52 (whole year) On column A I have work-side and on each column i'm typing in manually name of employees. Just...