Display all results, even zeros, nulls, and blanks
Mon, 1 Sep 2008 21:16:01 -0700
I am trying to do something that not be possible. I posed a question a few
days ago, and received some good help, but couldnâ??t quite figure out how to
get a solution worked out. Anyway, I guess the best way to explain the issue
is to say that I have a table with sales data for Q3 and Q4. I have another
...
|
Re: Simple query with criteria dependent on current form value
Mon, 01 Sep 2008 18:55:44 -0600
On Mon, 1 Sep 2008 17:23:00 -0700, TravelingHT
<akwillims75@hotmail.com(stopthespamer)> wrote:
>I know you 2 like putting the code in the "Row Source" propertie of the
>PetID combobox. But it is visually easier for me to use the query, is there a
>problem with using a query?
Kalvan's code *is* creating a ...
|
Check for a non exact match - eg serial number with 1 digit differ
Mon, 1 Sep 2008 14:57:01 -0700
Hi All
I need to do a search for serial numbers - I need to find exact match (easy)
but also check for miss types - ie find any numbers that have one or two
digits different to something thats already in the table. The serial number
is 14 digits long and is always letters and numbers.
So if I do a check o ...
|
solution to table
Mon, 1 Sep 2008 13:23:00 -0700
I am bit new to access, trying best learn. I have small problem :
My one of investment like this :
Invenstment a: Investment B
deposit date 1/01/2001 1/6/2006
amount 25000/- 30,000/-
period 3 years 10 ...
|
WWW.ANUNCIOS-24H.COM
Mon, 1 Sep 2008 20:19:28 +0200
PUBLICA TUS ANUNCIOS GRATUITOS EN MAS DE 40 PAISES : COMPRA Y VENTA ,EMPLEO,
SERVICIOS ,CONSTRUCCIONES ,REFORMAS ,...Y MUCHO MAS . WWW.ANUNCIOS-24H.COM
...
|
data type mismatch
Mon, 1 Sep 2008 05:23:01 -0700
I have a linked table from an SQL warehouse.
first query
SELECT dbo_Account.OriginalFeeTable, Format([TakeOnDate],"mmm") & "-" &
Format([takeondate],"yy") AS TODate, Val([InitialDebt]/100) AS debt
FROM dbo_Account
WHERE (((dbo_Account.OriginalFeeTable)<>"00") AND
((Val([InitialDebt]/100))<>"") AND ((db ...
|
Show create table
Mon, 01 Sep 2008 10:42:10 GMT
Hi All
I'm using Access 2003 and MS SQL server. Does anyone know if there is
anything in access which is like the MySQL command "SHOW CREATE TABLE"?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200809/1
...
|
|
|
Hamilton Khaki Navy Frogman Auto Chrono Titanium Black Mens Watch
H77746333 Recommendation Discount Watches
Sun, 31 Aug 2008 23:53:00 -0700 (PDT)
Hamilton Khaki Navy Frogman Auto Chrono Titanium Black Mens Watch
H77746333 Recommendation Discount Watches
Hamilton Khaki Navy Frogman Auto Chrono Titanium Black Mens Watch
H77746333 Site: http://hamilton-watches.pxhelp.com/Hamilton-wristwatch-3357.html
Thank you for choosing http://www.pxhelp.com/
Qual ...
|
Simple query with criteria dependent on current form value
Sun, 31 Aug 2008 17:44:01 -0700
Here is where I currently am
The record source for the combo box Pets in the Form frmPetsAtVisit is a
query based on my tlbPets.
frmPetsAtVisit is a subform of frmVisits, which is a subform of frmlTrips
(the misspell of frmlTrips is intentional)
Both tables tblTrips and tblPets has the same foreign key ...
|
Display crosstab query result with conditional formatting
Sun, 31 Aug 2008 16:49:00 -0700
I have read several posts here but none [so far] seem to answer this question
of mine.
I have a crosstab query: shows all kids alpha sorted in four grade levels
nested within four schools - next to each kid's name are three columns,
showing test results for three points in time during the school year.
I ...
|
