I have a table that contains dates and times of downtime for factory
machines.  I need to create a query/report that calculates how many minutes
a machine was down during a certain time period.
I have four fields in my table; downdate, downtime, update and finally

I've been racking my brains to figure out the best way to approach my problem.
I have test results I need to organize:
ID          date          labnumber(unique)     result
1           10/01/01        1                          15.0

  cnn.Execute CommandText:="[QueryName]", _
              RecordsAffected:=vbNullString, _
              Options:=adCmdStoredProc Or adExecuteNoRecords
has been used instead of "DoCmd.RunSQL".

This is data I took over and trying to make sense of.
They were tracking the work an operator was doing on their shift for the
day, I am having a problem with the afternoon shift, their shift ends at 12
midnight so when they worked a press (#4) from 10:18 PM to 12:00 AM I get a

I want to create a year to date date restrictor.  Right now for all of my
queries I have used between 1/1/05 and 12/31/05.  I want to create one that
will automatically roll over to the next year raither than changing it to
1/1/06 and 12/31/06.  Can anyone help?

How do I remove the decimal point from fixed numbers but leave the double
zero after the decimal.  Currently I am using the Replace() command but if
there are two zeros after the decimal it drops them; I need them to remain.
Currently

Hello, I have this textbox in a Access 2000 form, which is a memo type
where we keep our notes for a record.  Whenever there's new notes to
add, they're piggied back to the existing notes.  (new notes are
entered at the end of the last notes).

As part of a query I would like to create a "field" that displays only
the first line of a memo field in a table.
The first line of the memo field is the title of a report.  I would
like this to be displayed instead of a seperate field which is the

I am sure this is simple but I can't seem to get it to work.  I have two
queries, the first one with 1 field (SSN) there will me multiple records in
this query, the second one has 7 fields, one of which is (SSN).  I want to
show all the results from query two where the SSN is not ...

Why can't I enter data in a query where the tables are already joined?

I have a large table with several fields in it.  Some of the fields have
values of 0 and numbers larger than zero.  I need to write an update or
append (not sure which) that will read all of the values and convert any
digits >0 to a 1.

In an Access query, I'd like to have an expression that takes the current day
of the week (Sun through Sat) and returns the date for Saturday (in "Short
Date" format) of that same week.  Please advise.

Hello, I hope someone can help me with this.
I have a SQL 2000 Database with 2 tables, Inventory and Orders.  We use
a Access 2000 database as our front end and I need to update the second
past due date in the Orders table with today's date.  This second

Hello, I hope someone can help me with this.
I have a SQL 2000 Database with 2 tables, Inventory and Orders.  We use
a Access 2000 database as our front end and I need to update the second
past due date in the Orders table with today's date.  This second

I have a field in my query with addressess (numeric and alpha characters
combined...ie 111 W Main Street). I would like to write a criteria for just
part of the field (select out all "Main Street" records). I tried the [] and
* commands but those did not work. The field is a text ...