I have a simple table and have built two queries on this table each of which
filters for a different condition.  I've then put both of these queries in a
new query to produced a recordset returning both results filtered for (to
link child and master in a subform).  I've joined ...

I want to create a query that will update all records in a table that are
null by an incremental value. In other words I'll run a report on Monday and
run a query that will assign a value of "1" for each of the seven records
that were entered that day. If I run a report on ...

I'm sure this is something ridiculous I'm overlooking, but I can't find
reference to it in any of our Access support books, nor on various websites.
I've got a sort of HR/Contact database built, very basic with all the info
in one data  set.  One field, titled COMPETENCIES, is set ...

Is there a quick formula to look at a date and calculate the last day of
that month that isn't a Saturday or Sunday.  Date field is InvDate.
Thanks
Brent

I'm attempting to use a query to add up the charges in a record from a
table and two corresponding records in another table and then return a
result if there is a difference between the known total and these
calculations.  My query below works fine for adding up charges from a

I have three queries that are similar and I want to combine them if
possible.
The first provides a list of organizations and a total of the number of
"subgroups" assigned to each one.

What is the appropriate syntax to referenc the value of an option group in a
query? I currently have:
CODE
Like

I have several columns that contain numbers.
I want to create a query that will only display those rows which have values
that are progressivly larger...ie if column1 is less than column2 and
coulumn2 is less than column3....and so on to column10

I have a Pass-thru query that displays results almost immediately. But
if I try to look down in the table of results, it takes forever. Also
if I try to do a make table using the Pass-Thru query it takes hours to
make the table.

I'm setting up a access database to keep up with gas receipts, mileage, etc
for company vehicles.  I need to be able to calculate for each vehicle the
number of miles traveled each month based on the odometer reading.  On every
gas receipt the odometer reading is recorded.  What ...

Thanks in advance for any help, comment or otherwise, anyone can provide for
my question. This is the first time in over three years I have worked with a
database and I have inherited two tables that are related but have not
relationship built in. My primary goal right now is to ...

I am trying get a count of records for a lead location where the record
number is greater than a certain number.  It does great for selecting and
counting the number of records for each lead location but it bombs when I try
to give it criteria for which records to count.  What am ...

I ran into a uniuqe problem, that I'm hoping I can get a different
viewpoint on.
A year or so ago, I wrote a database application that pulls
Subcontractor informtion (address, etc) from a 'contacts' table and

I am looking for a way to number the rows in a query result.
Example:
Row1  Row2
A        B

I'm attempting to use the Replace function in a query and get a "Function
Undefined" error when running query.  However,  the Replace function is
working fine in a module and debug window in the same database.
I have some text fields with double quotes in them (ie: like "this") ...