|
|
data type mismatch by
scubadiver
I have a linked table from an SQL warehouse.
first query
SELECT dbo_Account.OriginalFeeTable, Format(,"mmm") & "-" &
Format(,"yy") AS TODate, Val(/100) AS...
|
|
2 |
117 |
|
|
Run the Delete Query on Exit? by
J.Bennett
I have a database that is used to provide quotes for storage buildings. If
the customer wants to actually purchase the building, then the user proceeds
with...
|
|
4 |
227 |
|
|
Show create table by
Jay974 via AccessMonster.com
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"?
--...
|
|
6 |
146 |
|
|
|
|
5 |
122 |
|
|
COUNTIF equivalent by
Sue Compelling
Hi
(Using ACCESS2000)
I have a field which is populated with either 1, 2 or 3 (this is
derived from an option group). (NOTE - my select query incl fields...
|
|
6 |
98 |
|
|
|
September 1st, 2008 02:21 AM
by LBRT
|
2 |
138 |
|
|
Check the duplicate records by
Dimitris
Hello. There are a lot of duplicate records in a table. I used the duplicate
wizard to find them. I also have a checkbox named "dupli". What I need is to...
|
|
1 |
144 |
|
|
|
|
1 |
117 |
|
|
|
August 31st, 2008 05:38 PM
by Glint
|
7 |
100 |
|
|
|
|
1 |
126 |
|
|
Combining Records by
Shoelaces
I am sure this is not the optimal manner for doing what I want to do, but my
lack of skills has led me to this path. Anyhow . . .
I have a query that has...
|
|
4 |
136 |
|
|
Access 2003 by
Tay J.[_2_]
If I were to look upinformations stored in a table using a query (thru a
form) to see if I have previously been to an address, can I have the system
ask me...
|
|
1 |
84 |
|
|
Trim in Query Error by
Hackneyr
We use queries to extract data from our G/L. Our location numbers are stored
in 12 characters, 7 preceding hard spaces and 5 characters. In Access 2003
was...
|
|
0 |
98 |
|
|
|
|
1 |
107 |
|
|
Finding the value in a string by
nadesico
Hi,
I am trying to find a unique value in a string. For example, the value in
my field is and another has a
value of , and I am trying to create a query...
|
|
2 |
86 |
|
|
Duplicate in a querie by
Brendanpeek
i need a query that will display the values in the field but i do not want
the query to show duplicate values.
|
|
2 |
80 |
|
|
Complex Queries by
cybin992000
hi! maybe you guys could help me. i have two tables in msaccess, the first
table has two columns, the first column contains the names of columns in the...
|
|
1 |
81 |
|
|
IIf expression in design by
drober
HELP Please... I am trying to build an IIf statement in my design view but
can't figure out how to get results compare to skill type. I figure I am on
the...
|
August 30th, 2008 12:23 AM
by drober
|
5 |
119 |
|
|
|
|
1 |
120 |
|
|
Display Query by
Cyndi
Is it possible to display query criteria on the report that is generated? For
example, the query requires the user to enter the start and end dates. Can...
|
August 29th, 2008 11:11 PM
by Cyndi
|
2 |
94 |