I have to run a query to generate the modified data like group a contains 30
perpon, group b contains 40 person, group c contains 20 person, group d
contains 10 person. And there’s a table Relation ,which shows the relation
between some people and group, for example, alex is in ...

i have a file which is export from UBS. i need to separate a field which is
contain PO no n item. how i can make it to two field?
eg in UBS:
PO No

I originally posted this in the wrong NG..............DOH!
Can anyone assist me with the following.
I would like to insert this:
SELECT tblPupDetails.DateOut, tblPupDetails.PickUpNo,

When I try and do this I get the phone numbers side by side and each
customer next to each supplier. So its a complete mess.
Is it possible to create a list of both customer and supplier telephone
numbers in one query, not having to do to.

I need suggestion as to what to do with this error.
Problem caused by Microsoft Access 2002: consider upgrading
The problem was caused by Microsoft Access 2002, which was created by
Microsoft Corporation. Microsoft Access 2002 is in its "Extended Support"

I have a table which contains the orders from a customer. This table is
filled out of an excel sheet which I import.
The datastructure is as follows :
PartNr    OrderQty    DelivDate    PendQty

This expression in a query returns a date differance.
If the dates in both values are the same it returns "0" which makes sense
but is there a way to default a zero to "1"?
Another words is an appeal is opened and closed the same day I need this to

I would like to either create a query from the following Union query or modiy
the SQL to allow me to sum the all of the key counts. When i try to create a
new query from this one and add a column with the following expression i get
error messages

Hello Please Help,
I have two tables table1, and table2. They both have patient information
with  patient_id as unique identifier.
Table1 has 26609 patients and table two has 26638 patients which is the same

I am trying to import a txt file into a DB and keep getting the
following error message:
Property not found.
This file worked at one point, but no longer does.  Can anyone point

When I run in append query (which has worked in the past), Access now tells
me all but 7 records violate some unforseen validation rule. All the records
contain the same fields of the same length and there are no validation rules
on any of the fields in the target table. Help!

I need to merge several fields in a query and the fields that I have to
merge must have a specific lengh even if data that is in the field has not
that lengh.
Imagine:

I have several phone numbers I would like to use as criteria in a phone
number field. I have these numbers in another table.  Is there an easy way
of using the phone numbers in that table rather than entering each number?
I'm talking like 300 numbers.

I created a report based on a several combined queries.  I made a number of
changes throughout and now have it working 100%, but I have one small
problem.  When I open the report I get an Enter Parmeter  Value msg box.  The
Parameter is:  " Purchase Order.Purchase Order ID.  If I ...

To append a single record, without getting a warning when a record
already exists, I found out the following syntax works fine as Query
in MS Access:
first create a simple 'products' table...