I can not believe I'm even having to post a question like this. This
is stupid beyond imagination.
running access 2000, and I'm TRYING to create a query using date
criteria.

How do you create a binary field for dates, when you are going to update or
append that field?  I've tried using eg. "stop_date: null" or "stop_date: 0"
in the make table query that creates the field, but when I run my update
query to add the date, it puts either just numbers or ...

Hello all....
I have a table that has a few fields in it, including Project, Contractor,
Start Date and End Date.  I would like to run a query that shows how many
Projects (rows) that a Contractor is assinged to that have over-lapping

I want a crosstab query to return all records unless the user specifies a
particular account number by updating a combo box on a form. The criteria I
have in the crosstab query is as follows:
IIf(IsNull([Forms]![Form Name]![Combo7]),"*",[Forms]![Form Name]![Combo7])

I created an Access Report using the Wizard. The report shows or
prints the alternate blank pages. That is second, fourth, sixth, etc
pages are bank. How do I suppress the blank pages??

Hi, I have a data source table with a customer name field and various metrics
fields, I'd like to sum metric "a" based on customer name being like "abc"
and another sum of metric "a" where the customer name is NOT LIKE "abc" in
one query, but I can't seem to figure this out, but, ...

I  have a table with just one column with 3000 rows. I need to export into a
CSV file so that it looks like this:
data1,data2,data3,data4, etc.
Is this possible? I've attmpeted using the Export Wizard but can't get it.

I have a form which has on it the field for entering the barcode of a
book, a field for the student ID and a date field for returning of
book.  When I put this information in I want it to run a query that
updates another table where I have the barcode of the book and the

I have records with dates. How do I set up a query so when a report is run it
would show records older the 30 days, records older that 60 days, etc.The
fields i have are Date received ,Invoice date ,Invoice Number which  are from
the invoice table. There is also vendor number ...

On the many side of a one-to-many, my many table looks something like
this:
(The " --- " is just to help you see when a new patient begins)
###

i have a form/subform that i have added a new field to, netamt. I added the
field to the table, then added it to my query, then added it to my subform
that is in my form. The field is set to currency and has =Nz([Quantity],0)*Nz
([UnitPrice],0) as the ControlSource. The number in ...

Hello, I am trying to write what I assume would be an update query. I have 2
fields, acct_num and brnch_num in my table. I need to combine these 2 fields
into a new field called cust_num. So, if:
brnch_num        acct_num

I have a table with a fields that contains both a date and time.  I am having
trouble pulling a query using a Between (this) And (That) criteria.  Can I do
something like I can in Excel where I can seperate the two pieces into two
seperate fields?

How can I query [Comments] and and return all of the record that contain the
work "retired" or "Retired"?
Thanks!

I created a query, and it seems to work fine and I am pulling data from it
to populate three reports.  But, there is a weird thing that happens.
When I open the query in Datasheet view then scroll along to the right all
of the data suddenly becomes #Name?.  What is this and is it ...