I have a start date text formatted as 8 digits (DDMMYYYY). This query says
there is a data type mismatch but it has worked before.
SELECT CVDate(Format([StartDate],"00\/00\/0000")) AS expr1,
Count(caisreport.StartDate) AS [Count]

I have a Table (Q1) with several fields (Site, Rep, Cust, ID, Prod, Serv,
Date, Act). I need to randomly make a couple of selections. There are three
"Prod" types. I need to select two "Prod" per Rep. There are about fifty Reps
so my end number of entries should be 150. The Table ...

SELECT ActivityDate,  tblEmployee.first_name,
(Select count(*) from tblDetails
INNER JOIN tblEmployee on  tblDetails.Employee_ID = tblEmployee.Employee_ID
where

I need to run a query that appends records from a table to the exact same
table in another database. I run it, and it it refuses to add the new records
saying that there are key violations. And yet if I do a copy and paste
append, it will work. (see SQLcode  below)

I believe I may need to set my structure up different, but maybe not.  We
wanted to build a database that is basically just data entry of a written
event form that is filled out.  There are several 1 to many relationships, so
I broke these all out in tables.  The main table, ...

We were just upgraded to 2007 from 2003. I have a database that I use every
day that has different errors in it now that it has been converted to 2007.
One is 2007 doesn't seem to accept Date() anymore. I use this to query only
current dates. Is there something I can use to ...

I have a function that works great, it makes active stores not active.
Here's the code.
For Each varItem In Me.lstActiveStores.ItemsSelected
strSQL = "UPDATE [MasterTbl] " & "SET [Indicator] = FALSE " & _

good day
I have a table with two fields holding and paid both are yes/no
holding is checked on when invoice received and approved
what I need to do is run a query to uncheck holding and check paid but I

I am having an issue getting a query to work in access 2003. I have some
linked tables, from an sql 2003 server. I have written the T-SQL statement
and it works the way I need it to for the report:
select assigned, ae, createdby, typeofrequest, count(Typeofrequest) as

i'm trying to find the most recent date from this field.
dbo_TRACKED_OBJECT_HISTORY.complete_time
Here's the queries or SQL can somebody help me.
SELECT dbo_UNIT.serial_number, dbo_UNIT.part_number, dbo_UNIT.part_revision,

Im using ACCESS 2003. Ive created two queries using  Query Design wizard. Now
what the problem is that, i want to bring the result of those two queries as
two fileds of a single report.
           Im a beginner to ACCESS. Its urgent. Please do help me. Thanks

Sku    April FCST    May FCST    June FCST    FCST AVG    % of total    Cumulative % total
OIF00224    352,872    380,025    390,843    374,580    20%    20%
MCX40    282,570    273,120    291,480    282,390    15%    35%
GSP03953    158,550    198,810    170,100    175,820    9%    45%

I've been stuck on something for 2 days, and I can't figure it out.  The
varItem is giving me a "0" value, and it should be giving me a concantenated
text value.  (i.e. 1 - Monroe NC)  
I'm trying to update a tables yes/no [Indicator] field, based on multi

I have a table with 50,000 rows.  The value in the col are currency and all
need to be divided by 100 to show the correct currency amount.  The column
name is "Payment".  I'm thinking this is easy but I'm just not able to figure
it out.  Below is an example from my table.  Thank ...

I have a table where each record consists of a series of posting dates,
posting items and amounts.  I need to display those  posting items and
amounts for each record that meeting a given date criteria.  I am able to use
the switch function to but it will only display the first ...