query1 brings the following results:
AccountNo DocID CompanyName
1               5       Salvation Army
1               5       Salvation Army

I just upgraded to MSOffice 2007 and went to open a query. A message
"this actioon or event has been blocked by disabled mode" What is that about?

Hi, i'm not quite a beginner, but having 'mental block' with where to start
constructing a query.
I have two tables of data: SAP data & Vendor data. Both have the same
fields, but with different data. The Vendor data contains records that may

I have a database that is replicated.  It has been working fine.  I designed
5 new queries.  When I right click and bring up the properties, the option to
make the queries replicable is no longer lit.  I have not had any problem
before adn all other queries are replicable.  What ...

I have tblEmployee with [employeeID], [name], [startdt], [enddt], etc.
I want to build a chart/report which will give me the number of employees
employed by month (Jan07, Feb07, etc.) .
I can create a query with an expression for Jan07 which returns a true

I have imported 2 tables with similar structure, and want to generate a new
table containing data from both tables, as well new fields that compare the
data from the two tables.
Eg. Table 1 = Users (Name, Surname, DOB)

I am new to MS Access.
I need to enter multiple data when running my MS query prompt.
When the Enter Parameter Value prompt appears, I can't enter more than 1
data value - using [Enter data] in the Design.

Hi,
I was trying to figure out a way to get certain records in my
tbl_STOCK_REORDER that have a certain Stock_ID number to update a record in
its main corresponding table. For example a record with ID: SD001 is from

I don't know if this is a query question or a report question or both, but
I'm really confused.
I have a table (tblGL) with the following fields in it:
dtmDate = Date Field

I have a query in which I have included the tblmonth, which has a number and
its corresponding month according to fiscal year...i.e.,
Month, MonthID
October, 1

I have a table that is written to programmatically that has fields for
INDATE and OUTDATE. In my stupidity, the line of code that records the date
for these fields is: !INDATE = Now, instead of: !INDATE = Date
The date is recorded in General format a la: 1/12/2008 3:01:57 PM. ...

I need help creating a query in MS Access 2007 that will take a determined
value (FC) and run a query against it showing what percentile the value
should fall into based on person's age?  Is there also a way to put actual
parameters defining the expected curve within an access ...

I have a complicated calculated field in a query, and the builder keeps
truncating my expression. Is there any way around this limitation?  If
necessary, I can post the calculation - but the basics are a switch by the
value of class, then a switch by value of position to get the ...

I have created a query on which a report is based that shows authors of
articles. In my data entry form I can enter two author's names for any one
article, however, if I want the report (and thus the query) to show BOTH
authors' names in the event that there are two (or three or ...

I have a query that calculates the number of planned and then the completed
innovations by month. I would like to be able to have a running total of the
planned field and the same for the completed, in other words a cumulative
total of each as the year progresses. Below is the ...