There was a post that said "Bear in mind that you cannot store a date without
a time - a default time of 00:00:00 is assumed." (See Pete, 10/27/06)
I am having a lot of trouble because of the "time" that is inexorably
embedded in the date.  Can someone tell me if the default time ...

sorry to hassle you all but I have a table where each client may have more
than one mulitplier attached to their file
eg.
Client 1 . . . 1

I have a table with a field that contains the component ID number for 800+
items. The ID numbers are as follows:
1.1-1
1.1-2

I have a query using multiple tables and multiple primay keys that is
returning the wrong information for one field that is not part of a multiple
primary key.  I have set relationships between the tables and joins are in
place in the query.  Can someone please advise what might ...

In the query design view, I don't know why certainly I can not see the table
field view at the bottom, I can only see the top table link view. I scrol
down, but still could not see. What happen?

An update query updated a large number of field values in the wrong field.
It added the value YED-14- to the left of the existing values.
Is there a way to remove the YED-14-  without doing it manually or
requesting IT to restore the database from backups, and return the values to

I have a table that lists a set of diseases in several columns (say  2
columns, Disease1, Disease2). I want to create a new column (let us say,
Diabetes) which would be coded as "Yes" for a row for which any one of the 2
columns has an entry for "Diabetes". Otherwise, it would be ...

I have a table which contains a date column and what I want to return is the
2nd newest date for each specific Item.  For example
Product       Date
1                1/1/2008

I am not too good at writing SQL, and I don't know how to do this in design
view:  I would like the results of my query to be equal to ([this] AND
[that]) OR [the_other_thing].  I don't know the correct sytnax - please help!

Hi,
I am trying to create a query with the following criteria:
1) Prompt user to enter data from a list/combo box - Required data
2) And have the option to enter between dates if date values are not entered

A record contains PARTID and COMPONENTID fields.  There could be multiple
records per part.  For example:
PARTID    COMPONENTID
030.11A    030.090

I have a query with fields    ID, Level, a1, a2, a3, a4,......... a40.
The fields a1  to  a40 will either be blank or will have an integer value
from 1 to 5.  I'd like to add a calculated field, called Score,  that will
give me the sum of these 40 columns divided by (5 times the ...

Hi,
Is it possible to show a crosstab query on a single form (at the Detail
section) and have variable (not fixed) number of Value columns to display?  I
know that I can insert a datasheet subform for the Crosstab query, but

I have a database that tracks EZ Pass tags, after several years of use we
have adapted a bar code scanner into it, now the scanner adds 2 zeroes in
front of the ez-pass tag number,  and the users all these years have not
entered the zeroes in front of the field.

Hi,
I have a table with alot of account information.  However, to report on
certain accounts, I have to manipulate a few of the column data and create a
new column with the correct information.