An append query that works in Access 97 does not work in Access 2003.
Error is "Microsoft Access didn't add 3 records to the table due to key
violations"

I am desperately trying to get a query to work as a subreport.
but each time I run it I get "Data Type Mismatch in Criteria Expression"
error.
Without the headings the query runs fine.

My problem
2 tables:
PROBLEM
PROBLEM: PROBLEM_ID

I need to extract the line number of a query.  This is for comparison and not
for a unique indentifer.  My overall goal is to create a procedure that will
reset my count dates for cycle counting.  I want to get an equal # of counts
for every day (some parts are counted quarterly, ...

Hej All
I've created an Append Query with params:
INSERT INTO tblDepartments ( DepartmentName, Created, Modified )
SELECT [p_DepartmentName] AS Expr1, Now() AS Expr2, [Expr2] AS Expr3;

i have a table with cost records and a dateyear field
on my form i can use the =Sum([cost]) gives me running total but i would
like to add a text box that can use a public variable 'curyear' to select
currrent year totals. i have a query that does it but how do i get the text

Can someone point me to where the missing opoerator is
Update  Employee
Set Employee.[PPL 2 hour Limit]='yes'
FROM  qryAbsentSum

Hi,
I'm trying to get the email domain name from an email address. So the text
between the @ sign and the first '.' after the @ sign. I'm aware this is not
100% correct as some mail addresses have more '.' behind the @ sign, any clue

I have a query that I wish to show only those records within a date range.  
Querying it like : >#01/01/2005# works fine, however when I want to make it
user definable using : >[Start_Date] it just ignores the input and shows the
full list.

Firstly I opologise to experts.
I have a database of ALL businessess in a town with many fields including
postage address, phone number, propietor etc etc.
I also have a checkbox to indicate if they are a member of a certain

Please help me in this issue
if stidcmb value is 0 then i want run the query without any criteria.
IIf([Forms]![searchfrm]![stidcmb]=0,"",2)
this doesnt work..........

repost as last posting dissapeared:
I wish to number records, in natural order from 1 to n
There is no numerical or date comparison or sort that will allow be to rank
using the techniques listed (that rely on there being count() records in my

I have tables that are essentially lookup tables that are displayed in the
form as combo boxes.  For some reason, everytime a record is added, it adds a
record to my lookup tables (which should be static tables).  Any idea what
may be causing this?  I am working from a query ...

I am generating a running sum of Shares for an investment tracking
database in a query as follows: (SELECT Sum([Shares]) FROM
[Transactions] AS [Transactions_1] WHERE [Transactions_1].[Period#] <=
[Transactions].[Period#] AND [Transactions_1].[Security] =

I have changed my QryProducts to include a separate field for units, but I
want the position of the Units display to default to the right of the query
column.  That is, right hard up against the RHS.
Please help, Frank