I have two tables. One is a "sale_details" like this
sales#        date                        item
1            16-12-2006            mobile phone serial#123
2            16-12-2006            computer serial#456

I hope someone has seen this issue before.
I have a simple database for tracking friends, family and club members.
I have a query to sort them.  I have the criteria written like this:
Like [What Type?]&"*"

hiiii
i want to know the answer of this question today i really need it i seach
alot but find nothing i hope will you find the answer
this is a question:

Howdy,
I have a table of staff members who serve different locations for a
percentage of their time. So employee X may spend 20% of his time at location
A, and 80% at location B. My table that lists each employee/location

I would like to know how I can set it up in a query so that the weights that
I have in one field will be displayed in Lbs and Oz.
So if my weight is 9.21875 Lbs Can the query display the weight as 9Lbs &
3.5 Oz.

Hello,  Sorry for the newbie question here.  I am trying to create a query
that will count unique data from a field based on a date.  Here is an example
of my table data.
Color:     Date:    

I need your help if it makes sense.  I tried to test it and I didn't
get any result because of missing information.  I'm not sure if I miss
something.
Public Function Result (year_A,year_B,factor_C,year_B,tenure_D)

I am trying to associate the part no. of products in one table to their pics
in another.
example:
PN                                          PIC

I have a query as an ecample that returns several values in a field....dogs,
cats, and eleph.  How do I change the eleph to elephant?  thanks

Problem
I am trying to create a query from two unrelated tables, I have
tblSales                                       tblSalesTax
SaleID                                         SalesTaxID

I have set up a number of parameter queries but would like to insert them
into a form.  This is in order to have a dedicated search form for various
parameters without having the pop-up’s appear.
How do I insert a Parameter query, and associated command button in to the

I am perplexed.  Seems like it should be so easy, but...Can you help? My
table has:
Client                   PaymentDate              Amount
AutoIncrementingPaymentID

What would be the best way to update these data: I have a table of Contacts
with the fields:
Name
Employer

Dear NG - Yes, I'm brand new so I will apologize in advance for being
such a pest.  Lets say you run an update query and at a later date
decide you want to see those records that were updated.  Short of
creating a new variable such as "ModbyQry4568" and setting it to 1 in

Hi all, i am quite new to Access and have struggled for a few days tryiny to
find a way to achieve this.
I would like to be able to return records that have a selling price of
within 10% of the value i enter as in [enter selling price].