I have several Rows and Columns. I have each row become visible if a check is
placed in an option box. If an entire row is not visable (no matter what row
it may be). how do I get the rows under it to take its place so there is no
blank rows.

I would call this an emergence!  There are people throughout the state using
this database and now it's down.  Strange thing is that no changes were made
in days.
Anyway: I have narrowed the problem down to a statement in a query.

I have a transaction table with a field named PersonID
I want to select all the fields of the table with only the last 10
trans of each person sorted DESC by date
can I use the select top here?

I want to build a query which will have LoanQty, OwedQty and ReturnedQty
OwedQty = LoanQty-ReturnedQty
However, this item can returned separately which means Item1 can loan 4 item.
Then return separately...

There are many postings dealing with append queries and they have helped a
great deal with the other one I was working on, but this one is different.
I am wondering if it is possible to run an append query from code with two
different sources for the data.  There will be three ...

Can a group by clause be used with an input parmeter?
select count(field1),field3
from Table
Group by field1, @field3  <--user inputs what field

I've created a query from two tables, where the query has criteria from both
tables. What I would like for the query to do, is only give me one instance
of any duplicated MBRNO, and all the records/instances that are not
duplicated. I've looked at other posts and can't seem to ...

Hi, this is a re-post of a question not fully solved.
The resulting records will NOT have a unique key, which completely throws me
off, and the books just don't discuss this type of stuff in much detail:
I have records from two tables that are related.  I would like to filter

I'm trying to add the numbers from two different text boxes together
in a third text box. Pretty straightforward, right? Well, instead of
getting the sum of the two numbers, Access is putting the number from
the first text box next to the number from the second text box like

I want my report to show if my product is (specked) or (non-specked)
In the query i am able to get only one of them to show up. I have tried use
OR, and AND. They still only show one.  I have created two drop down's on the
form and have tried combinding them and that does not work ...

I am creating a query from similar tables and cannot get the results I am
looking for.  One table shows all pay period end dates and includes a number
or a 0 the other table only shows a date if an adjustment was made, most of
the time there will be no record at all.  So on ...

I have a database of training courses taken by our employees.  It has a form
with a drop-down to select a specific employee for a report (rpt By Specific
Employee).  Upon selection, the report appears in print-preview of that
specific employee.  The record source of the report is ...

I have a query where the results are either populated with some number, or
blank.  I would like to populate the blank cells with the number 0 so that I
can calculate later.  Is there any way that I can tell my query to treat
blank results as 0?

I have read many posts (and found code in a book) referencing how to
used a "dummy" function to call a variable into a query. But it's not
working for me. Can someone tell me what I'm doing wrong?
In a Public module (starting with Option Compare Database), I have

1. How to use values from [Form1]![Text1], in query?
   Field in query is datatype Yes/NO.
When I put in query criteria values Yes/No, working OK.
But, when I call this values from [Form1]![Text1], not OK.