I am moving the Access database to Sql server. On conversion of one of the
queries I get the message "Field too small to accept the amount of data you
attempted to add". When I exclude one of the fields from the query it works
fine. But I never had any problems when the backend ...

I have a table with the ambulance call data. I need to create a query that
calculates the time difference between "T2_Notified" and "T3_Enroute" fields
in minutes. How would the formula look like?
Thanks

I have a query that I want to show the records only created by the person who
is currently logged in.  However, I have two specific log-in names that I
want to allow to view all records in the query without restriction.  Here is
my IIF:

Is there any syntax for this, or is it the case that Jet does not support
this data type?

I have a SQL Statement that includes the foollowing:
Transaction.Program, Transaction.[Special Use],
Sum(Transaction.OrigBudgetAmt) AS 0059
FROM [Transaction]

Just wanted to say THANKS to all who have been helping me lately. It's
really appreciated and I'm definately learning.

I have a table that lists Trouble Reports (TR). I need a query that will
show a cumulative total for each month over the year, like:
Date        CountOf Opened            TotalOpened
Feb '05        45                                45

Hello...
I know almost nothing about MS Access. So please bare with me.....
I am using Access 2000.  I want to know how to write a query that will
search for records that are duplicates, then search for the records that has

I want do extract first and last name of employee to seperate fields from a
combined name field e.g John Smith  I have no problem when just two name but
with more  I do. e.g need Mary Jones from Mary Jane Sarah Jones. Please Help

I created 3 tables and made a query with the query wizard but when I run the
query the data I entered into the tables does come up. It shows no records.

Okay.  I'm still having problems with a query by form.
I am querying a field (DateComp – type Date) in a table (t_Requests).
On form (1_Main) there's an option group (Status_Grp):  Closed (value
1/Default), Open (value 2), All (value 3).

I have a query with two columes
WagesDate:Format([Date],"m")                              WagesAmount
Wages Table
Group By                                                               Sum

Can anyone see what is wrong with the following query?
SELECT * FROM Tickets
INNER JOIN Choices2Ticket ON Tickets.TicketKey=Choices2Ticket.TicketKeyLink
INNER JOIN Choices ON  Choices2Ticket.ChoiceKeyLink=Choices.ChoiceKey;

I am really struggling to get the output I need from 3 tables in my db.
Essentially, I need to report on months in which a payment has not been
received (by the 'practice') at all, or it has been for the wrong amount.
I have the following tables:

People -  I got a great and correct response to my earlier query:  Just to
refresh..  I have tables thus:
I have a table (called KEYWORDS TABLE) which looks like this:
WORD                 | onum   | nnum    |