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 ...

I'm trying to figure out a good way to show actual timecards versus
scheduled.  I have an Access 2000 database that is pulling info from a FoxPro
database to compile this.  I currently have a query and report that pull
everyone's time sorts it by department and by day and totals ...

I am generating reports for a customer based on activity for the previous 2
working days. There is no activity on weekends, therefore i need the query
results of: "[Arrival Date]=Now()-2" to exclude weekends.
Help.

The problem I am having is with an SQL statement I wrote in VBA but the
examples I am giving actually come from a Query where I could let Access
write the SQL statement for me.
I have a table that has 1143 records in it. If I run the following Query it

Howdy Folks,
I have a table that contains a series of asbestos sampling dates at
several different locations. A simplified version of the structure is as
shown below:

I am trying to run an append query with criteria from a select box stored in
a form. However I am getting a run time error 3075 saying there are missing
operators.
This is my first conversion of an SQL statement into code so I am lost. Any

Hi to Everyone
I have a table (tblMunka) with the following columns: JobId;
PersonalId;AreaId;StartDate;EndDate;ActiveJob
I would like to a query which tell me how many personal was in a term in an

I'm in desperate need of help.  We've got an Access 2000 database that links
in some Progress database tables, one of which has more than 255 columns.  I
need to run an update query in a column that is somewhere beyond the 255th
one.  I have no problem running a select query to ...

Good Afternoon All,
Does anyone know of the function (if any) that allows me to merge multiple
fields together
Example

Using Access 2003, I have Table1 with fields name, Banquet50 and banquet 80
among others. Name is a text field and Banquet50 and Banquet80 are check
boxes. What I am trying to do is search the records in the table and display
the name of individuals that have Banquet50 or ...

I have a table: (for example)
Client_Name              Key_in_time_date
Alle                      01/01/2008 01:53:00 PM
Claire                   12/02/2008 05:53:00 PM

I need help with a select query that will select the next two (2) [duedate]
in table and return those records where [duedate] >= today

Why is it that whenever I import forms, tables, modules, reports, and query files that all my query files import corrupted.  When I open up (in design view) a query file all my field names begin with an "Expr#", I.e., "Expr8: budglabel".  I then have to go into each query file ...

ozip       dzip     BillofladingNo  ship date  transportprice  Actual
Wgt
07022     19856      12345           9/12/06     56777
12390