i have next due date field and maturity date for about 100,000 records      
how can i calculate no payments left on these loans    how would i do it in
query

I have tow valum whish = 0 when I add them the result = null i use Nz but
nothing change.
Thank you

I have 2 queries.
My first query shows all jobs done in a time period. 39000 rows
My second query has jobs numbers with appliance types.
I want to show the 39000 rows with an appliance, but when I combine them

Hopefully someone out there can help...in my table, i have a field called
product.  The products, or at least an example, are:
tape - two sided
tape - masking

I am wanting to list poeple between ages that I specify.  I have the
birthdates entered, and am using "Age: Int((Date()-[DateOfBirth])/365.25)" to
get the current age.
I am then using the Criteria in a query "Between [Enter Start Age] And

iif ([age] <30, ".08"
between 31 AND 34, ".10"
between 35 AND 39, ".15"
between 40 AND 44, ".25"

I am developing a hostel software. I want to allot a hostel out of 7 to some
600 students 100 in each hostel. My table fields are [ID], [Name], [Hostel
Code]. I want to pick a student randamly and allot hostel. How to do this.
Please Help.

hi
I am new to access and struggling a bit with a query.
I have three tables, one containing members with details (phone etc)
next table(meetings) contains all the available meetings that have been held

Thanks for taking the time to read my question.
I don't know if this is possible but I need a query to tell me if my new
booking conflicts with any bookings already made.  If the query returns
nothing, then there are no conflicts.

Need a formula that returns Prior Day # - Current Day # for same column, When
Prior is diff record for prior days date.

I am having problems with my sql for my table, I have vertical figures
which I want to put in horizontally in an sql query:
Original data
Name         Amount    Quantity

We're using Access 2003 and on any given day any report set to print
landscape prints out portrait ***only for the first time printed***.  If we
then print it a second time, without changing anything about the report it
prints landscape (the way it is set to print in page setup). ...

Hi, Is it possible to extract only the numeric element of a text string.
i.e. 123 Somewhere Avenue, thanks, Garry

I am creating a simple bug tracker (using Access) and i created
a history table to log the bug history.
The history table contains details like ProblemRecordNo (PRN),
HistoryDate, RecordStatus, Assignee, Reporter,etc. The PK for this table is

This piece of code in my module trackes the date someone deletes a case by
recording it into a table.   Could you please help me format it to also
capture the Time....