I have a property management database that has many of the same tenant names
but at different street address  but same mailing address.  I want to run a
query that only shows the tenant once.

I am using Access 2003, front end tables are linked to the back end, links
are checked every time the db starts.
In my front end, I had 100 % of the relationships gone in 100 % of my
queries. Checking the backend, all relationships were present and intact.

I am trying to create an append query with two additional fields.  The
first is a date field.  That I do not have an issue with.  The second
field I want to be an autonumber type field.  I have
input the following expression into the query:

Budget is our income and sometimes this is positive.  I need to make this
column in a query all negitive values.
I am using the IIf function but it is not working.
Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1,

I have four fields which I want to merge into 2 fields:
Run_From
Run_To
Run_From_Postcode

I have a database for tracking equipment repair requests.
Each shift, if they have a problem with a piece of equipment, will
enter a "concern" into the database.  If both shifts have the same
problem then a request for "countermeasure" is created.

I have an excel report which draws data from access. The excel table looks
like this:
Each project is reviewed by two people
Reviewer Name | Reviewer1 | Reviewer2 | Total last 12 months

Please help me to access as administrator or Power user.

We have a table of Index Returns for every month end starting in 1992 to
current date.  In access I am trying to calculate the Annual compound return
for 10 yrs, 5 yrs, 3 yrs and 1 yr.  
Originally this calculation was done in excel and each index would have a

Greetings, thank you in advance for looking.  Basically the database tracks
spend based upon the vendor and who is spending the money.  Problem is that
not all spenders spend with all vendors and vice versa.
I need to create a crosstab query that I can take out of access and paste ...

I have the following error relating to a UNION query I am trying to write in
SQL.
Extra ) in query expression (((HEALTHCHECKS.[Actual Date]) Between Date()
And Date()-"90") AND

I have Access 2003 database stores Time in GMT. I want to convert this GMT
time into localtime when I display in Report.
How should I write the query?
Thanks

I have created two Forms from the same Query, one of which picks up people’s
names from a related Table and the other of which, correctly does not.
The problem is that when I post the results  to the Client ( as an Invoice)  
through the common Query the names are automatically ...

I am viewing an SQL db thru Access 2000. Sometimes when I  do a query, I get
data for records that don't match the criteria.
For instance, I want to search for all clients = abc in tablea (code,number
returned,amount received,client). I add all fields to the query and in

Is it possible to apply StrConv([field],3) query only to those fields where
contents are in all lower case, all upper case, or all lower/upper with
hyphen?