I have data sets that have married couples, the couples have the same last
name, I want to create a query that shows the last name plus the name of the
husband and the name of the wife on one row.

In the last year I have been using Access 2000 alot.
I have noticed that  in running queries that when a database reaches 2gig
size the queries will no long run and will give an error that reads "Invalid
Argrument".

I know when I build a query that I can prompt a user to answer a question,
for ex. [Please list Last Name], which will filter the data.  My question is,
instead of the user entering the data can you have a combo box come up so
they select the correct field.  I want to do this so ...

I'm getting the error in the subject when I execute this query.
SELECT [Table 1].Key
FROM [Table 1] RIGHT JOIN [Query Date Visits] ON [Table 1].Key = [Query
Date Visits].Key

I do not understand how Access relationships get updated.  If I have a one to
many relationship and the same field in Table1.Sports as in Table2.Sports
then how do the records in table2 get updated.  Do I need to input the
information in both tables manually (twice)?

i need to make an update query that updates the "in stock" column of my table
after i put in a quantity on an invoice form.  i have two drop down menus
(technically i have 20, i have ten sets of two) the first selects a type of
product (ie hard drive, processor) and requeries the ...

Not sure if I have broken any rules by reposting but I assumed that I did not
get any replies due to the timing of the first post, Saturday was probably a
bad choice.
Apologies in advance for the long-windedness of this post, I don't know how

Consider the following two queries:
1) SELECT COUNT(*) AS BinTickets FROM Ticket GROUP BY Bin;
2) SELECT BinKeyLink FROM User2Bin WHERE UserKeyLink=User;
The first query counts the the number of tickets for each type of Bin. Each

I have a perplexing puzzle that I cannot figure out.  I have a report that
shows payroll for a date period.  I have created a table that holds all the
payroll items and their effective date.  I am trying to design a query that
will be able to return the proper amount for the ...

I've got a couple queries that I've created in an MS Access database. I'm
accessing the database from an ASP website. Is it possible to make use of
the queries stored in the Access database from the ASP website?

I have a table with multiple columns of data.  Rather than manually using the
"Replace" option with the "Edit" menu to search for data containing the
character "(" and ")" and replacing it with "[" and "]", I would like to see
if I can use the Update Query to accomplish this task ...

can one write hierarchical queries in msaccess

Please could someone tell me if this is possible. I have 3 number fields -
TypeTime, ResearchTime and ProofTime.  Users will enter in minutes the time
it has taken to complete a job eg. 70 , 30 and 35.  
I have a query that then adds up these 3 fields as follows

I have two tables that have a field called [Product number](text, width 255).
Both tables contain entries in [Product number] that does not exist in the
other table. I want to be able to list exactly which product numbers these
are. So I use the queries:

Hi!
I created four simple select queries, Query1, Query2, Query3, Query4 - each
query uses the same table but retrieves a unique set of records. Then i
created a continuous form, and slapped FOUR Checkboxs, box1, box2, box3, box4