Display Last Few Records

[SicNeMeSiS]

Hi,

I have a DB that Displays the table as data is being entered into it. I was just wondering if there is a way to limit the number of records being displayed rather than displaying them all so it does not bog down after too many entries being viewed. Thank you in advanced

Sic

 

[Kryst51]

A table is for storage, You really should be using a form for input.

 

[SicNeMeSiS]

I am using a form for the data entry, when items are submitted, it is displayed in a table below.

 

[Kryst51]

Can you post what you have, minus any sensitive data? I am not understanding what you are asking then. Having what you are looking at in front of me will help.

Is there any field that marks a record as being before the other? Like a date or something?

 

[SicNeMeSiS]

Here is a dummy version of my database. Checklist is the form i am talking about. The area displayed in redish is what i want to be limited to say the last 10 entries.

 

[boblarson]

Change the query underlying the query for the list box to:

SELECT TOP 10 taskTable.taskName, taskDetailsTable.dateTimeStamp, taskDetailsTable.taskNotes, taskDetailsTable.taskComplete, taskDetailsTable.notCompleteReason, employeeTable!LastName+", "+employeeTable!firstname AS userName, taskDetailsTable.cdcDate
FROM taskTable INNER JOIN (employeeTable INNER JOIN taskDetailsTable ON employeeTable.employeeID = taskDetailsTable.employeeID) ON taskTable.taskID = taskDetailsTable.taskID
ORDER BY taskDetailsTable.dateTimeStamp DESC;

 

[Kryst51]

OK, in the query behind your list, open the QBE right click in the portion of the screen that the tables appear in and click properties. This brings up a box called "Query Properties. The is a row in that box called "Top Values" You can type "10" in there. The problem is, however, is that some of your records are for the same date and time, so your query actually returns 12 records. You can also type a percentage in there.

There is probably a better way, but I am not sure what it would be. Does anyone else have any other ideas?

 

[Kryst51]

Change the query underlying the query for the list box to:

SELECT TOP 10 taskTable.taskName, taskDetailsTable.dateTimeStamp, taskDetailsTable.taskNotes, taskDetailsTable.taskComplete, taskDetailsTable.notCompleteReason, employeeTable!LastName+", "+employeeTable!firstname AS userName, taskDetailsTable.cdcDate
FROM taskTable INNER JOIN (employeeTable INNER JOIN taskDetailsTable ON employeeTable.employeeID = taskDetailsTable.employeeID) ON taskTable.taskID = taskDetailsTable.taskID
ORDER BY taskDetailsTable.dateTimeStamp DESC;

You are so fast!

 

[boblarson]

There is probably a better way, but I am not sure what it would be. Does anyone else have any other ideas?

You gave one good way. The other way is just to open the query in SQL view and type TOP 10 after the word SELECT.

And in this case just open the query in SQL view and paste what I posted because I used the real thing . But either way will work fine.