|
|
Error 3290 on CREATE TABLE query by
Darizotas
Hello,
Whenever I try to include the restriction WITH COMP to a field table in MS
Access 2000, it raises a 3290 Error indicating an error syntax at CREATE...
|
|
9 |
125 |
|
|
Designing Query - Help Please ASAP by
tmdrake
I have built a form with (3) combox's that display different selections. On
that form I have a command button. I would like to built a query based on the...
|
|
9 |
126 |
|
|
Finding Duplicates by
Jason[_15_]
Hi all,
I'm running Access 2007 and would like to know if this logic is correct for
searching duplicates in two tables.
I'm trying to find my renewal rate...
|
|
9 |
87 |
|
|
Join Query by
Esaw
I am trying to create a query that displays data from a combo box and
autofill in a subform (I hope that makes sense) But when I set up the query
it shows no...
|
|
9 |
145 |
|
|
SQL String by
[email protected]
Hi. I am working on an Access database that someone else developed.
I have the following code in the database. I need to modify the SQL
string statement to...
|
December 11th, 2007 11:57 AM
by clk[_2_]
|
9 |
129 |
|
|
Invalid Argument (error 30001) by
pon
I am receiving a error " Invalid Argument" only when I run a Make Table
Query . But the select query is working fine.
I also get the error when I import...
|
|
9 |
168 |
|
|
|
November 28th, 2007 02:10 PM
by Harry
|
9 |
162 |
|
|
Sort in an IIf statement by
Huber57
To all:
I am using Access 2003.
I have a IIf statement in a query that looks like this:
Owner: (IIf(="Smith Properties","SP#" &
(IIf(0,,"XX")),"SD"))
The...
|
|
9 |
144 |
|
|
Using Code to build criteria by
FBxiii
Hi.
I have got a form where the user can select various options for a report.
One option I want is for them to be able to select either All Customers or...
|
December 20th, 2007 05:55 PM
by FBxiii
|
9 |
131 |
|
|
create one table from six queries by
F0zziebear
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 |...
|
|
9 |
104 |
|
|
Columns based on Date by
jenniferspnc
Not sure if I've started this project the right way, so please jump in and
offer suggestions. Basically we track monthly totals. I have columns for
each...
|
|
9 |
104 |
|
|
|
|
9 |
144 |
|
|
please help with a query by
Alex
Select DISTINCT No_, ,
FROM
Where .=18 AND .='SALES TERRITORY'
--AND 0 AND IS NOT NULL
UNION
--** This part is not working giving empty...
|
October 5th, 2007 08:04 PM
by Alex
|
9 |
185 |
|
|
VBA code in query for new field? by
bluesky
Hi -
I need to run a query for a mail merge and I need a field that will either
return “her” or “him” depending on my “sex” field. My sex field...
|
|
9 |
133 |
|
|
|
|
9 |
167 |
|
|
Queries not retrieving the required data by
Zeenabu66
My boss has asked me to create a query to find for example all songs by an
artist in a CD Collection database. The query can only retrieve some songs
for...
|
|
9 |
175 |
|
|
Query condition by
Robin
Hi All,
I have two tables for managing our sales orders. One has the order header
info such as customer name, account number, etc and the other stores the...
|
|
9 |
128 |
|
|
Data Changing Issue by
Karen
Hi
I am running some queries using a form I created and for some strange reason
some people are falling off and coming back to the report when I run the...
|
October 22nd, 2007 02:27 PM
by Karen
|
9 |
132 |
|
|
Append Query Error by
kalyhan
Hi Everyone!
I am trying to run an append query, but it errors out at "Duplicate output
destination 'EmployeeID'."
I have checked (and re-checked), I see no...
|
October 26th, 2007 03:06 PM
by kalyhan
|
9 |
140 |
|
|
Count Question by
NeonSky via AccessMonster.com
Hello,
Quick question.
Is there any way to do a count referencing a field like below and outputting
the number to another field, for...
|
|
9 |
133 |