I have two tables...
 One with a complete list of addresses and road names (32,000)
 The other with a list of addresses and road names as follows (1,500)
   Either a pair of records with the same road name, but one is marked

I download a report to a text file, unfortunately, the file is in a "report"
format. The report list line items in groups. There is a header for each
group which identifies the user responsible for the following records in the
group. I created a field in the table called REP. But ...

I only want a query to look at duplicates by MR and sorted by MR.
I want to be able to delete the records I choose to delete (manually).
Is there a query that I use that modified the query I have (this query finds
all records) I only want to display and delete duplicat I choose:

I have five names
David
Joe
Smith

Are there limitations to the size of queries..(ie, number of columns, etc)?

Hi
I hope that someone can help?
I have a table with two fields "Days since last contact" and diary date.
I want to have a certain sort order whereby the records are sorted by diary

Hey All,
I have a small table with only about 19,000 records. The fields are:
ID, Establishment, Address, City, State, ZIP, Address2, City2, State2,
Zip2

I have a field of IP addresses: i.e, 000.000.000.000. I want users to be able
to enter only a subnet and be able to return only those 255 IP addresses.  
The first 6 characters are always the same so they will enter the third set
of numbers. I know I can hard code the query for: ...

I have a single table with the following fields:
NPA, NXX, Line (all with data) and BTN (Blank)
I want to populate the field BTN with NPANXXLINE. I don't care what the data
is in NPA, NXX, or Line as I simply want them to be combined as a string in

Hello,
I have a query established to provide data that populates a report.  For
those fields that the user did not enter in any information, I want the
report to show the text "Not Entered."  I have successfully created the

I am using SQL view of query to create my tables. Appreciate your help with
my questions  :
1. How do I create a table with composite primary key ? I have created one
with 1 key, but how can I create them with 2 primary keys? Could you tell me

I have a table called "task_list" [taskID(str255) start_date(date)
due_date(date)] which contains lists of job types requiring attention.
I'd like to create a continuous form based on this information that
would show all the unique tasks, how many are not yet due to be

I have a query with the following criteria which are based on a form with
two unbound text boxes:

The column that uses this criteria is based on a field with the "general

Hi gurus!
I am running a simple append query to bulk add records into a booking table.
For each booking added I want to include a unique Booking reference
calculated from a Function.

My DataBase have one field i use Date/Hour the name is NASCIMENTO
In my querie i need return alls birthday using the Date of my local machine.
For example: today is 4/4/2007 i need return al birthdays of april
thnak's for atention