Not sure whether this question belongs in Queries or Forms.
I have a Query By Form set up to search a database of contacts. There are
two instances of the name "Welsh" in the Contacts table, but only one of them
appears in the Search Results form after using the Search form to ...

Hola,
I have the next problem.
In one table I have a productname and the number of cartons that fit on a
pallet

Hi. I need to have a special criteria to my querie.
I have a Employees table, in that table I have this fields: (the type if
this fields are Yes/No)
  - Manager

I plan our events using Access. At the moment when I'm given the dates for
an event e.g. 1st July to 17th July  I have to manually create a new record
for each day.
Is there any way in an update query I could type in my constants (event

I'm making a database of computers called 'Workstations' and one of my
fields is called PCType and has 2 lookup values, 'Desktop' and 'Laptop'. Now
I'd like to show the total number of Desktops and total number of Laptops in
my table but not sure the best way to do it. Any ...

I have a table that gets replaced each month with new data from a feed, no
problem. I need to insert into this this table once the new values are there,
the same records each month. I will not be populating all the fields in the
table with values. I am using the INSERT INTO ...

I have a form that I use to run queries and I have 4 different
variables that can either be blank or not. I have tried to create
conditions where I am able to leave some or all blank or some or all
filled in and get the correct results returned. This is the code I am

Hi all! I need help creating a query that allows me to edit a field on the
grid.
I'm in query design view and I import the table ORDERS and the query
QRY_SUMOF_ORDERDETAILS as a subquery. I joined the PK of table with the FK

I have the following expression in a query of a joined table.  
([LastName]) & ", " & Left([FirstName],1) AS Expr1
Some of the results are null and the result is a comma by itself.  When the
comma is by itself I want to get rid of the comma.

Hoping someone can help me resolve a seamingly simple task.  I have a query
that finds records in Table1 that do not have matching fields in Table2 and
then I want to delete those records from Table1.  I'm obviously a novice but,
I usually get by.  Need help this time. Thanks. ...

I’m using a subquery to assign a FinishPlace to athletes competing in a race:
SELECT tblEventResults.fkMeetEventID, tblEventResults.EventResultsID,
tblEventResults.TimeResult, (SELECT Count(*) FROM tblEventResults AS T WHERE  
T.TimeResult <  tblEventResults.TimeResult AND T ...

Hi
I have a CrossTab Qry with 2 Rows and Columns with a dates:
"Oct-06","Nov-06","Dec-06","Jan-07","Feb-07"
I have put the above dates in the Properties/ColumnHeadings dialogue, but

I'm new to Access and unfortunately been tasked to take care of someone
else's DB.  The question I have is, I need to make a report that uses 12
fields of data.  But the thing is, I need to have the report to categorise
the 12 fields in into 12 categories.  If I make 12 different ...

I get this error message when I try to run the query below:
Between operator without And in query expression 'Data.[Zip Code] BETWEEN [5
DigitZip].[Zip I]'
SELECT Data.[Zip Code], Nz([5 DigitZip].State, "Not found")

I’m having a problem joining three tables into one query.  I can join the
Investment Table and the Fund Table but when I try to add the Institution
Table and run the query it comes back blank.  Here are the details:
Table Funds: