I am working on a friends database.  They have a series of differnet records
each records pertains to a piece of music, who played it and when.  Some
pieces have been played in 4 or 5 different years.  If I run a query to find
all pieces played in 2005 it only gives me those ...

I am trying to search a table by date using a combo box.  I want the
combo box to be populated by dates from a table, however many of the
dates are listed in the table more than once.  Is there a way to only
display the dates in the combo box once?

Good Morning, Afternoon, Evening :)
I need some help on this thing a colleague must do: compare 7 contact lists
she has in order to ensure that they are no duplicates (a contact can be
present in each of the contact list). I thought that Access was the tool for

I have three fields: Start Date, End Date & Duration.  For example, Start
Date is 12/10/07, End Date is 12/10/07 and the Duration is a calculation
field and the result is 0.  How can I make it 1?
Thanks,

I am attempting to add two currency fields together in an Access 2003 Form by
inserting the following expression in the Control Source:
=[1_Price] + [2_Price]  Extraordinarily it strings the values together like
$20$50.

I have a text field. I want to make a query out of that field without
disturbing the original text field value. I mean that this field will be next
to the original text field in the query
My original text value of the field for example are as follows

I'm trying to build an expression to show that if there are 6 or more people
in a group that there should be a discount on their rate, otherwise show the
regular rate. I've been trying the following Iif but I keep getting a msg
about how Iif's should be enclosed in parenthesis... ...

I have a query problem that I'm sure has come up before, but I couldn't find
a thread with it, so any help or links to other threads would be appreciated.
So I have a table in Access 2003 that has two columns, gameID and Category.  
Games are allowed to have multiple categories and ...

I have a emplyee database.  I need a select query to show records with values
in certain fields.  lets say fields A, B, and C. each field may have any
combination of the values "null"or "not Null":
A            B                 C

This works in a query design view column:
WeekOf:
IIf((Weekday([Date])=1),([Date]-6),(DateAdd("d",-(Weekday([DATE])-2),[DATE])))
It looks at the date field and assigns it to the 'WeekOf' which is always

I created an update query in a database that is in a trusted location.  When
I veiw the results from design view, it is correct, but when I run the query,
the table is not updated.
How can I make it work?

Hello -
I have a field in a query
ExpDate: Format([ccExpMonth] & "/" & ([CCExpYear]+2000),"Short Date")
Where ccExpMonth and CCExpYear are integers so I had to combine  two fields

1. Problem:
Contents in table fields of data type "memo" are chunked to a length of max
255 chars, if the fields are delivered by a query having the key word
"CONSTRAINT".

I have a database listing the names and addresses of people. There are often
several family members living at one address. I want to end up with a list of
addresses without duplicates.  The addresses are in 3 columns. Unit#, street
# and Street name.

I have a report I run where I query date, shift and department from a table.
In my query, how can I make the shift and/or department optional?  Without
creating a bunch of different reports I want to be able to see all the data
from an entire day within a dept or both dept's on a ...