I have a table with this type of info - I need to populate the Unitprice with
the previous non-blank price - Is there an easy way - self taught Access.
Thanx
Seq          ProductID    ProductName    TXDate    UnitPrice    Units

I use a query to display purchases by origin (PurchOrigin),
seller(CustomerCounter), buyer(PurchCompID)
and quantity during [Start Date] and [End Date].
It is grouped by PurchOrigin, CustomerCounter, PurchCompID and sums the

I have an Access back end database on a server and a front end in the same
server directory. Multiple users open instances of the front end for
simultaneous data access. One user needs to run action queries that require
all other users to first close their instance of the ...

I am tracking a variable for different subjects over time.  I want to find
the date and value of the FIRST local minimum, NOT the global minimum for
the subject.  
Here is some sample data:

I have a table that contains fields for scores in an athletic event and the
rank of that score within a subset of competitors in a certain skill and age
level.  the SQL string created by the query GUI is
UPDATE Entries SET Entries.Rank =

Good Morning,
is it possible to reference a local table in a pass through query? If so can
you show me an example.
Thanks

I need to know where to go to check the date I installed SP2.  My restore
date must be close to that date? (Due to virus infection)
thx
kenny

I am trying to get a result of returning every 4th record in a database of
thousands.
Not sure how to go about the process?

Well, I know this question has been answered many times...but, well I'm new
at access and all the answers were based on SQL which I'm not familiar with.
Baiscally I need to run a query to check for records after a certain record.
The date is taken from a simple date field in a ...

Working on a make-table query to make a table to send to IRS to report
1099's. Many required fields contain various number of blanks. That's easy
when the field is supposed to contain 2 or 10 blanks: "  " or "          ".
But when it gets to 207 blanks, isn't there some way to ...

I am new to Access and need help with a query to find duplicate records.  The
situation is that I have a list of students who entered our college in the
Fall of year X.  I need to see how many returned the next Fall of year X+1.  
I created two tables with the data from the ...

I created one query to find the data i needed to "mark for delete", and I'm
trying to use a second query to refer back to the first and only "mark" those
part numbers for deletion.  Is there a simple way for me to have this field
automatically "check" it self?  

I am collecting data for a call center.  They now want to measure the time
on a call in minutes. So I can collect the beginning time as Stamp1 and the
ending time as Stamp2.  I am using the now() function to collect the data.
How do I subtract the 2 fields and get minutes as a ...

Hi, when I am running the following query, my order by statement is unable to
execute when I use aliases in my query, because it seems to forget aliases
AND full field specifiers after executing a subquery.
The following query is the only one I got working:

I had designed a query with subquery that worked fine but lost it after one
of Access famous hiccups. (Function was gone from my code). Upon redesigning
I can't seem to get it to work:
SELECT Count(*) AS Aantal