Hi,
Someone wants me to try and run this querry in Access to see what data it
brings.  (it comes from a web form that pulls the e-mail addresses from a
table in an access database)

How do I add a unique ID to a table when I am using a make table query in an
Access project database?
The database is rebuilt every evening so I can't define it in the table
designer.

I have a table that has three fields with a 'loss reason' where any of the
three may be populated or all could be blank:
Company           Loss1             Loss2             Loss3
A                      No interest

I need a query to retrieve only the latest "note" for each "project" in my
database. The "note" table is linked to "project" by a field called
ProjectID.  Each week I update the notes for each project that I am managing
but often, there is no change so we might as well use the ...

SELECT Ctmid , CtmName , CtmAddress1 , CtyCityName , StmStateName , CtmPhNo1
, CtmWebsite  FROM (StateMst RIGHT JOIN (CityMst RIGHT JOIN CustomerMst ON
CityMst.CtyCityId = CustomerMst.CtmCityId)  ON StateMst.StmStateId =
CustomerMst.CtmStateId) RIGHT JOIN CustomerContact ON ...

Good Day all...
 I am trying to run an update query from a Subform on a mainform.
 I am wanting to run the qrypdate on the close of an invoice report.
below is my code for my update query, but when I try to run it just from a

Hi.  The following query retrieves no records.  If I remove the WHERE
statement it works fine.  I understand it's probably because column 5
(Due Date) is calculated from column 4 (CalDate), but none of the
answers to previous posts seem to help.

I'm using Access 2002. I have made a function to create a field value based
on the values of other fields. All of these fields are text fields, so I
declare them as strings, but whenever I run the query I am getting a data
mismatch error. Here's the code. Any thoughts would be ...

I am running several reports from the same query (I change paramater
within the query then run the report). I want to be able to create a
invoice number and increment it by one every time I run a report. I'
guessing I need to create an entry into the query that does this an

Is there any way to set a date stamp to a file name?  I run the same queries
each morning and would like to send them to a server without overwriting the
previous file.  I would like to keep the existing file name but have it add
the date to the name each time the query is run.

I already posted this once, but perhaps didn't phrase it right.  I have an
Access 2003 Application that contains a linked table from a SQL Server 2000
Database.  (It was upsized from Access 97.)
The following Query SQL yields many records.

Does Access have the equivalent of the SQL 'IN' clause?
TIA,
Dan

I have a MS Access table that includes 7 days in a week. I need to make a
querie that removes dates that fall on a weekend. (So I'll just have data
returned Monday through Friday)
Thanks for any help!

I am trying to TOTAL (or Sum) an already calculated field I've added t
a query. It doesn't work to =Sum(field) in the report so I believe
need to do this in the quiery.
So what I need to do is do a total of the Expr1 fields. Do I mak

I am trying to achieve something relatively simple but it's not
working for me. Any help would be greatly appreciated.
In a calculated field, Aged Date, I would like to set up a parameter so
the user can specify how many days, greater or equal value, to display.