I have a date field "daterecieved" i would like to query for items over 30
days old where a completed field is null. Please assist. I am trying to get
the number of items over 30 days old if the completed field is Null. The
daterecieved it the item I want to use to capture the 30 ...

I would like to be able to group dates by month in my crosstab query,
without losing the date values. I am going to need to export this
query to Excel to do additional data processing and graphs. So I need
the month labels to actually represent dates, not strings of text.

Is it possible to call manged (i.e. .Net) code from an access database or a
way to handle access form/report events from managed code?
Jacob

I also have duplicates in my Database and have entered the following for:
- PrimaryID   = ID1;
- Table Name= TEST_MBS2;
- Duplicate is defined as the same ID, LAST NAME, FIRST NAME, AMOUNT, and

I have a full date.time stamp field and need a query to only pull records for
the current month and following month.

Keep in mind that I have most of the fields. the only thing I don't have
which should be include in the statement are the dates. I have the RACC
field, serving size, sodium, cholesterol etc... I just don't know how to do
this IIf statement

So I've got this nifty crosstab query that shows me my data broken
down over time. The rows are [Assessment Type] and [Question]; the
columns are from the [Assessment Date] field; the values are from
[Score]. So it looks like this:

I am trying to add two fields to Table A from Table B.
When AcctNo from TableA = AcctNo from TableB (here it is a primary key), I
want two fields added to TableA.  I have the fields created for TableA, but
the update query returns blanks.

I am trying to run a query that has these columns
"Catalog Name" "Date Entered" "Session Number" "Item number"
The Item Number is specific to the session number (i.e. Session 3 Item 1,
Session 2 Item 2) and there is one session per catalog per day. I want the

I have tables, forms and reports set up in my database that work perfectly to
track vacation days taken. The problem is in order for the report to look
right I have to put in each day separately.
Is it possible to enter a range of days ex: start: 05/13/08  End: 05/31/08

I need some help about the this:
I want 4 users using one MDB at sometime.
It is possible?...
The access don't lock the MDB?...

I'm about to transfer some data from on table
to another. Here is my SQL
INSERT INTO table1 (a, b)
SELECT (a, b)

I need to create a query that counts how many accounts have a specific
service, but there can be many occurences of the same service on an account.
Example
Acct 1234 has limited services for 3 devices.

i am creating a form where I have a search field. I want to be able to
search by the entire name or part of it. I have used a query that has LIKE
statement with % but it did not work for soem reason
This is the code I used

If I try to copy more than one cell after running a query it always includes
field names. I want to copy several cells in a line or the whole line and
then paste it somewhere else but it always inludes the field names which I
don't want. Is there some sequence of keys to hit where ...