I am trying to count the number of related records each member of an
organisation has.
eg.
main table with member specific info

I have a crosstab which counts dates based on headings ie training types,
however this produces null values obviously where there aer no dates, not a
problem...
just wanted to ask if there was a way of substituing a null for a 0, sure i

Hello,
I need to create a query that would do the following:
Return Field displays the primary loan Number if one exists. If no
loan # is designated as primary, but another loan# exists, than the first

I created a make-table query, but now I want to modify it so that it prompts
me for a new table name to create each time I run it.  How do I do this?  
Thanks,
L. Jones

I have a Client Acct Number field that might contain the patient's social
security number.  What would be the query to find these?

I need to filter the textbox content in the form( Serch Textbox) and it
should search textbox content in multiple field of the query.

Back in the days when I used to do FoxPro programming, there was a
function [RecNo()] which allowed you to get the record number of a
record returned from a query or table.  Can anyone tell if MS Access
supports this same functionality and, if so, what the function is

I have a query that makes a table here is the sql view of it:
SELECT tbl_AcctPricing.BLACCT, tbl_AcctPricing.BNAME,
tbl_AcctPricing.BLRECT, tbl_AcctPricing.[BLREC#], tbl_AcctPricing.BLPLIST,
IIf(tbl_AcctPricing.BLRECT Like

I have a query that worked fine in Access 2000, but fails in 2003.  It's a
simple update query to a linked excel file. I get the following message:
"Cannot update'(expression)'; field not updateable.

We have an Access Database that has the following specs:
1.  PatientCase Table
2.  Invoice Table
3.  Items Table

Here's the scenario:
I query my database and put all of the records into a recordset
In the recordset is a text field which I parse with a regular expression
This returns among other things a product code

This query used to work, but quit about few weeks ago.  I can't track any
software change, and it fails on all computers that run it.  
I'm calculating the # of work hours (8.5 hrs/workday) from the time a job is
started until Now() to identify it's age in hours.  The following ...

I have three fields one call Admin Review Date, Amount of days,  and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

We have a database that tracks a number of different actions that each have
a due date and a reminder date.  The actions are:
1. Declaration Due
2. 90 Day Declaration Due

can I somehow  disable my computer? I work midnights and have two teenage
sons.  I need to make the two computers inaccessable to them.,while im not
home. is their a way to lock them out temporarily with a pass word or
something.