Duplicate entries in a query
Fri, 4 Jul 2008 11:41:00 -0700
Hi. I don't know if I can explain what I'm trying to do. Maybe I'm over my
head.
I've got a car club database. One table is name/address information. Another
table is year/make/model information. The third is the joining table, putting
members and cars together. Some members have no cars. Some members have ...
|
charts not populated on replica's on my pc or replica pc
Fri, 4 Jul 2008 11:18:00 -0700
,this is access 2007 saved as 2003, charts come up ok on master automaticly,
but not on replica's. Any help, thanks in advance.
Al
...
|
Formatting a Number in a Query Field
Fri, 4 Jul 2008 10:47:54 -0700
All,
I have a field value that is formatted currency. I need to format the field
in a query to have leading zeros and retain the decimal values without the
decimal.
Example: Field A= 137.19 I need to convert it to 0013719.
I've attempted to convert it to a string and format it to"0000000", but that
j ...
|
Query Too Complex
Fri, 4 Jul 2008 10:41:05 -0700
I have nested queries that when run on a local table runs correctly. When I
switch the first query to use ODBC tables I get query too complex. If I run
the individual queries (in the nest) they work all the way to the very last
one (that the report uses). Other than the ODBC connection the difference is
loca ...
|
most close return
Fri, 4 Jul 2008 08:34:27 -0700 (PDT)
I would like have a query or method to get most close value like
following:
Code Value
A+ 95
A 90
A- 85
I would like to have the query return A+ if value is greater or equals
than 95 and return A when the value between 90 and 95.
Is it possible to have a q ...
|
Help to select record by checking multiple child items
Fri, 4 Jul 2008 07:42:00 -0700
Hello,
I have a table consisting of student names linked to another one with the
date and status of passed tests (one to many relation).
It does happen that a student passes after the 1st test or needs sometimes
to take it several times before succeeding.
We have something looking like:
Student 1 - dat ...
|
How to look-up ID#
Fri, 4 Jul 2008 07:28:01 -0700
In my query I use the following to look up a case number which is really the
Auto Number ID: Like [CASE ID#] & "*"
However, when I look up record 28, it finds all of the 2800s and not 28.
Any suggestions?
Thanks,
John ...
|
|
|
Simple update query question
Fri, 4 Jul 2008 07:11:01 -0700
I have a table containing city names. They are all in uppercase. I'm trying
to use an update query to change them all to proper case (first letter upper,
the rest lower). What do I put in the update to: field of the query to
achieve this?
TIA
KM ...
|
Really weird query responses.
Fri, 4 Jul 2008 02:57:01 -0700
Right, this has been confusing me for days now and I have thrown in the towel
and need to get some advice. I am getting some really weird results from a
query.
The background:
I have a table that amongst other fields has fields for the total annual
spend in years 1,2 and 3 of a contract. All the fields are ...
|
Subtract positive number from negative number
Thu, 3 Jul 2008 18:42:56 -0700 (PDT)
I have a query similar to this:
SELECT Sales.ThisYear - Sales.LastYear AS SalesDifference
FROM ThisYear, LastYear;
This works fine if they are both positive. However, I have an instance
where the sales for this year is negative and last year is positive:
ThisYear: -80,000
LastYear: 20,000
Result in Ac ...
|
