I'm working with a former developer's SQL Server database using an adp.  For
unknown reasons, the developer chose to concatenate date & time in the Date
field of a critical table.  My query needs to only pull out the Date part and
discard time, but I can't find a function that ...

I have a table with 'member name', 'spouse', 'birthday', 'spouse birthday'.
I want to set up a query to take birthdays for member and spouse on one
form/report.  I can do it separately, can they be combined?

My query will no longer accept new records.  It was working fine since it was
created approximately 3 years ago.  But this morning it does not give me the
option to add a new record.

Can i run an Update query from a VBA macro and, if so, how
--
cwatchowskiPosted from - http://www.officehelp.i

How do I run a query by month (as if i need to view everything by a certain
month)
Such as Field1 is my Date Field... How would I write this? I tried
[RADIO DAY] = MonthName (10, OCT)

I have a basic table with product data listed by day.  This table will
continue to grow every day since I will append each new day's data to the
table.  Here is an example of what I want to do:
Let's say I've got 30 days worth of data (30 unique dates).  What I want in

Can I not use the same table to which I am trying to append, to see if a record
already exists?  Here's the deal...
I have a table on my AS400 with multiple [utility] service records for each
location.  (Services are attached to a location.)  Not all locations have ALL

Zip Code field uses 00000\-9999;0;_ as the input mask.  What code would I
need to type in the criteria field to return a table which excludes all
records within a five-digit +4-digit zip code?  By using the <> with a
five-digit zip code only, it works correctly; however, the make ...

I have data entry form developed in Access. This data entry form is bound to
a database table. This data entry form has some textfields and a submit
button.
What I want to do is that when I press submit button. The record from the

I posted a question last week that I thought was satisfactorily answered,
until I did some further testing.  After reviewing the results, I can see I
was not 100% clear in my question.  Here's what I'm after:
I have a basic table with product data listed by day.  This table will

Does anyone know how to run a query on a field where the criteria is that
they have the same info in it?  Example, I have a database where if the
person has the same first name I want them to show up in a report.  Thanks
for any help!!

Here is the situation:
1.  6 fields that are 2 digits each
2.  1 check box field named "changed"
What I would like to do is track how many times someone changes data in any

I’m working with calculated fields that have percentages, but the data entry
is like 43.5% my problem is that in order to multiply and get related
percentage of a number I have to divide by 100. Access read the number as 435
and if I set up to divided by 1000 I still have the ...

SELECT tblTable4.var00003
FROM tblTable4
WHERE (((tblTable4.var00003) Between #1/1/2005# And #9/1/2005#));
Also returns the default date. Var00003 is a date field with a default of

I currently have for example a person that belongs to the same organization
but is a member in 3 or 4 different clubs.  The database has lets say 4
records for the same name.  I need to some how get them all together under on
name but with all the different membership numbers.  ...