I want to compare values in 1 table and identify only duplicates
Sam Armas

MyTable is as follows:
InvoiceNumber;EntityName;SupplierName;CategoryName;Spend
Invoice1;Entity1;Supplier1;Category1;Spend1
Invoice1;Entity1;Supplier2;Category1;Spend2

I have 2 dates/times which I need to take one from the other, however if
between these 2 dates there is a weekend I need to remove 48 hrs.
How can I check if a weekend falls between 2 dates? or for that matter a
number of weekends falls between 2 dates.

I have a table of staff who can perfrom a particular role, however some
people can perform many roles. I would like a query that only shows the
persons name once. Is this possible,
Thanks

I have to filter records from units of Kg, L, 5L, 5Kg, 10L, 10Kg, 200L,
200Kg etc.
But the numerical parts will be good enough, and shorten the list box.
How can I designate as paramers only the numerical part of the unit and

I have a date field and a time field which I need to merge together to be
used in a date/time comparison - any ideas how?

Goodmorning,
In my query I have a Bill date, I would like to know how I can have all
bills < than 90 days as well as all bills > than 90 days
Thanks!

I am using a function (fClientName) in the criteria of my query.  Is there a
way to show all records if this function is "" or null?
eg:  If nothing is selected then all records show.

is there any way to force a query or a report to give the first  10 for
example records of the whole results?
thanks

I have an sql statment that returns a memo field as part of the result,
proble is it isn't returning the full string in the memo field?
And yet i have other sql that does similar and it returns the entire memo
string.

I followed Microsoft's instructions for creating a ranking query at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946
but when I run the following, Access says: "the jet engine does not
recognize [Turn1].[Turnout] as a valid field name or expression."  

I am trying to create a Diff (or Delta) query that will return only data that
is different between two tables.  All the fields are identical between the
two tables and I am using a field such as SSN as the primary key.  I want a
query to return a line if Joe Schmoe's address is ...

I cannot make a secure connection with my bank & often cannot access google.
Can I download to fix this problem
jan

Please help!
I have a database that consists of physicians and their medical specialties.
They can have as many as 3 (Spec1, Spec2, Spec3).
I need to link multiple tables to a query so that the fields (Spec1, Spec2,

I am trying to select records based on the value of a combo box column. I am
using it as criteria in a query and referring to it as follows:
Forms!frmMain!subform1!combo25.column(0). However, when I attempt to run the
query I get the 'Undefined function in expression error'. I do ...