Hello,
I am using Access 2003 and am trying to write a query to create a temporary table of records based on dates entered by the user. The records should be random and the selection should only return 30% of them. I think I have the basic logic outlined below, but I cannot figure out the syntax for this query. If anyone could help me, I would appreciate it very much!
SELECT top 30 PERCENT table.date_final, table.ID, table.project, table.status
INTO tblTemp
FROM table
WHERE table.date_final Between (dateEntered AND Date() )
ORDER BY table.RandomNumber
I am using Access 2003 and am trying to write a query to create a temporary table of records based on dates entered by the user. The records should be random and the selection should only return 30% of them. I think I have the basic logic outlined below, but I cannot figure out the syntax for this query. If anyone could help me, I would appreciate it very much!
SELECT top 30 PERCENT table.date_final, table.ID, table.project, table.status
INTO tblTemp
FROM table
WHERE table.date_final Between (dateEntered AND Date() )
ORDER BY table.RandomNumber