I see I can update a table from the output of a simple select query. However
this doesn't work with a union query.
Is there a way to make a union query updatable?
Thanks,

I have 3 tables, Bills, BillAdjustments, BillPeriods, There is a many to many
relationship between Bills and BillAdjustments.
The Bills have a consolidated number for Adjustments by month by lease,
however, sometimes there might be 2 bills with 2 adjustments for a lease in

i am using Access2000 and want to create a querie that will reference
information from each field and record only once from 2 talbes.  They have a
common field of bill date and  CBR#, other fields are not common.

I'm having a problem that looks like this:
Date      Name1      Amount         Name2
1/22/04   Person A     50         Person V
1/22/04   Person A     150        Person W

I have a linked "table" to a SQL database in my Access 97 db. The "table" is
actually a SQL query/view.
How do I copy the SQL string from this "table".
I need to adjust it and run it in a Pass-Through query.

I have two tables, a personnel table and a qualification table.  An
individuals qualifies multiple times per year so has multiple qualification
records from different dates.  
How do I perform a query that only pulls up the most recent qualification

I would like to select/filter at random 30 records out of an Access-table of
1500 records. I know the option "Top" which gives me the possibility to see
the 30 first records of the table The problem is that this option is linked
to the way of sorting the table. So you will always ...

I have designed an append query to append all the records from 1 table to
another.  Unfortunately, I missed 1 field in the append design. Is there any
way I can now append this missing data to the existing records without
duplicating data and records as I know this happens when ...

i am using Access2000 and want to create a querie that will reference
information from each field and record only once from 2 talbes.  They have a
common field of bill date and  CBR#, other fields are not common.

I am building an app that is looking for the latest model of a
particular product. I am storing these results in a datalist. Below is
what the location and newest model fields look like:
Location - NewestModel

I have a table containing the following fields:  MemberID, HoursA, HoursB,
HoursC and HoursD.  I want to create a query that will give me the total
Hours by MemberID.  There will be multiple entries in to table for each
Member ID.

Good morning,
I have a DB for my bed & breakfast. I would like to create a query that
lists all rooms currently occupied.  I have a query with a field with the
starting date (DATE/TME field) of a stay and a field with the number of

I have a query with 3 calculated fields. I want to be able to exclude any
record where all three calculations are equal to 0, and include any records
where any one of the three has a value greater than 0, and I am completely
stumped as to how to accomplish this. Any help that you ...

Is there a way to hide duplicate records in a query, I tried to do it in a
report and it still shows the duplicate records.

Would it be possible to add some sort of identifier that is displayed to each
post? It would be easier to find/mark a thread of interest rather than
searching on a Subject or poster name.
And is there a way to search on a date? For example, subject and date to