Access Table Sorting/Query Last Function
- From: mb <mb@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Oct 2008 14:47:04 -0700
Hi,
I've been designing a database that basically works off two tables. From
the first table, I have a query that pulls information and populates the
second table. I've done this so that I can pull the last entered [Status]
for a particular [Category], [Initiative], and [Task], and use that as the
updated [Status] for all records in the second table with the same
[Category], [Initiative], and [Task]. In the first table, I have an
autonumber set for each entry as the primary key, and I've removed all
sorting and filtering from the tables. For some reason, however, entries
that are completed today and entered into the first table using a form in the
database have started from the top of the table and are inserted thereafter
instead of continuing from the bottom of all the entries in the table from
previous days. I was under the impression that if you remove the filter and
sort, the natural sort order of the table would insert new data to the bottom
of the table, which would work perfectly with the Last Function that I set up
in the query that pulls the [Status] information from the table. Since the
table is doing this weird sorting, I can't get the Last Function to work
properly; it keeps pulling the last of yesterday's Status. I've only had
this database up for a day, so I don't know how it will behave tomorrow, but
I need it to not behave like this. Can anyone help me figure this out please?
.
- Follow-Ups:
- Re: Access Table Sorting/Query Last Function
- From: Jeff Boyce
- RE: Access Table Sorting/Query Last Function
- From: Duane Hookom
- Re: Access Table Sorting/Query Last Function
- Prev by Date: Re: edit function in a table
- Next by Date: Re: edit function in a table
- Previous by thread: Re: Inventory Labels
- Next by thread: RE: Access Table Sorting/Query Last Function
- Index(es):
Relevant Pages
|
