The following SQL seems to cut my Memo text to fewer characters. My knowledge
is too thin to recognise which part is doing it. Help would be much
appreciated. The ID part is Ok, the problem lies in Field1.   Thanks
SELECT (Select Max(ID) from 01_LCControl where ID<tbl.ID) AS ID,

Hello all! This is my first post to the Access forum. I did some searching on
this, but didn't find an answer...
I have a query with about 10 fields on it. I sort ascending on field1 and
then ascending on field2, and everything works fine. Query results look great.

I have a subform that users use to enter in data. After they enter in the
data they then click on a button to print the record that asks them for their
ID (which is an autonumber and shown on the form) because there are multiple
records per user. My problem is that if a user ...

I have two tables (Entries and Payments) on which I am trying to compare
vouchers redeemed.  I am needing to link [Voucher_Num] from table Entries,
which is an AutoNumber field to [Number] in table Payments which is a text
field (I need this to be a text field as this payment ...

I have been having a frustrating time with what I think must have a
simple solution:
If I have an Access database with 2 tables, run a simple query and
then output all the information from both tables why is it that

I need to input serial BCD data to microsoft access via a com port. I thought
of running a scipt to control the flow of data but am unsure where to put the
data once I have loaded it and how to read that data into microsoft access.
Has any one done this before or have any ideas?

Access 2000 and SQL 2000
How do I pass a parameter to a stored procedure from ms access?

I need to find out the earliest entry date and the latest entry date for each
product code.  How to do this?  Currently I'm doing a primary sort by product
code and secondary sort by date, and then manually picking off the first and
last dates for each product code, but I would ...

I have a query that looks for 4 different dates (sort start, sort completion,
soft open, last day business).  Rather than using between in the criteria,
I'd like to use parameters to have the user enter the general start and end
dates of the search range, then bring me every ...

If i use the SQL command with out the on delete cascade it works but i need
it with the cascade delete on but then i get the error 'syntax error in
contraint clause'.
What do i wrong?

I am new to VBA programming
I have a table named 'CostCentres' which has got the cost centre structure
of the company I work for (It has many divisions, departments and cost
centres).

I have a UNION query that's merging the results of several individual
queries. When I run the UNION, i briefly see the results of the query as
expected. A few seconds later, i get a "Division by zero" error, and all
fields go to #Name? errors.

I have 3 tables as described below:
<Countries>
Country_ID (key)
Country_Name

My table contains records with duplicate IDs.
ID        Name
AAA     John Doe
AAA     Jane Doe

Hi and thanks for any help, I created a query based on 2 tables and for some
reason i have duplicate rows. What is the cleanest way to delete duplicate
rows?
is it to place "distinctrow" after the SELECT?