I am trying to comment some lines out in a union query and it doesn't
seem to work the same way that it would in a normal SQL query. I have
tried both /* Comment */ and -- before the line and neither method
seems to be understood when trying to run the query.

When I select a query from the page where my queries are listed as objects,
and export it, does the query run again before exporting or does it export
the results from the last time the query was run?
When I run a query (call it query 2) that queries another query (call it

Currently i have a query with the conditions on the date i.e. the user has to
enter the beginning and end dates of the data wanted. This is done using
'Between' in the criteria.
I am now looking to add another criteria, the name of the employee. What do

Hi I have a combo box that I can select 1-12 which then passes that selection
to a textbox (there are 12 textboxes).
if I select 1 to be in textbox 1 and then re-select for textbox 2 I want 1
not be visible in the combo box as it has been used so if I select 1,2,3,4,5

I have a table that has a number of fields in which there could be entries
from 1-11. also each participant has multiple rows for data entry (which was
an unfortunate result of having to work around access limitations on number
of fields)

My expression:
Expr1: IIf([GroupDeal],[WeightedValue]/([Time Span
(Months)]),IIf((Month([tblWeeklyPipeline]![SignDate])=9), [WeightedValue]))
It basically says if it is a group deal, then populate with the weighted

I have a table (TABLE1) with a ProductNumber field as primary key,
ProductName and Quantity fields.
I have a second table (TABLE2) also with the same fields but the number of
records is different.

Does anyone have knowledge of whether deleting the primary key of a table
could cause strange results from queries?
I have a GROUP BY (on a date column) query that returns results grouped
correctly up to a certain date and ungrouped after this date. The date is

I think this is a relationship issue!!
I have one table (t_customers) with years of data.
I needed to create a form linked to that "t_customers".
So, I created a new table, then a query with both tables, then the new form.

I am writing a query where I want it to check a form for the option selected
in a frame. I want it to choose a single item for the field if one option is
selected (option 2) and select everything except that single item if the
other option is selected (option 2). I am using an ...

    What expression could I put together to use in an update query that
would
return a string that ends in a space. The target string would be the
first

I am trying to modify a sql code based on John Spencer's thread on 2/5/07.  
Ideally I want my query result to show the count of each unique value grouped
by Lane, by LastName.
Supporting data:

I am currently using Access 2003. I have several yes/no fields of
staff-desired training requirements, whereby a yes/no is needed.
Example: A yes or no for training needs in Excel, PowerPoint...I have
already entered my staff informtion and checked the boxes of the training

I am trying to build a query that will allow me to search by a record
I select from a form using a combo box.  I want to be able to make one
selection from several different options and have it apply to that
using only one query.

I have a table with positive numbers. When I query said table the same
numbers show as negative. I checked all around but cannot get to the problem.
What am I doing wrong?
Thanks