I have two queries that work fine.  But when I union the two I get the error:
The field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data. (Error 3163).  I cannot find the offending
record or field.

I have this append query that works in an sql query, but does not work when I
run it in code on a form.  
docmd.runsql "INSERT INTO SDP ( MTMID, Station, F22 )
SELECT Seq.MTMID, Station.StationNo,  Round(Nz(DSum('TheMax',

i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")
to convert 16190748 seconds into Time format the result i recieve is

I am writing a Query to use on a Print command button in a multi value
continuous form.  However, the data that I am using is from multiple
tables and has a many to many relationship.
Perhaps this question will be better answered with a quick explanation

I have a query with the fields
Quantity (Count of ID's), Product, company.
My issue is to calculate the percentage for each company  in a query
When I put Quantity/Sum(Quantity)) I am getting subquery warning. How can I

I have an append query setup to transfer some records from a temp file to the
db.  This and some other actions need to be started from a macro - can open
the append query from the macro - what command do I use to make the query run?
Thanks

I have a column named "DATE".  The way the information is set up is,
YYYYMMDD.  I need to run a query by YYYY.  In other words, i need to filter
everything that is in year 2000 but i have information from 1999-2003.  How
can i run this query with this criteria.

Hi,
I have a form that has a few fields that cannot accept a duplicate value.  
Can anyone tell me what coding or command I can put in the "After Update"
property for each field that will let me know the value exists already in the

i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")
to convert 16190748 seconds into Time format the result i recieve is

I have a SQL Linked table for which I can not change any datatypes etc. It is
set to a Number DataType. When I select Percentages and 1 decimal. It does
not show the correct results. Example: I want it to look like this -49.9%.
The results show    

We have just converted our Access DB backend from Jet to SQL Server Express.
For the most part everything has worked fine, and we've seen the performance
improvements we expected (hoped for), with one exception. We have a dynamic
query-by-report tool that let's the user select ...

Dear friends,
Pls help me with the following problem:
I have 3 tables "clients", "invoices" and "detail_invoice" with one to many
relationships between them.

I am using an Access database for my website, and I want to be able to show
only a certain number of posts at the time. (For example; 1-10, 11-20, 21-30,
and so on.)
If I use this SQL expression:

Good morning...
We have a date field in a table of our database "10/12/2007" for instance
(mm/dd/yyyy).
I would like to determine what day of the week this date is

Hiya,
Basically I have a table tblRubbishPickUp which records the weight of
rubbish picked up
on certain dates, the table has the fields (Weight, Date, Driver) I