|
|
aggregate query by
Joshua6007
Hi,
I am trying to write a query that would allow me to calculate the proportion
of a specific value in a field against against the sum of all the values in...
|
|
6 |
88 |
|
|
Record to record calculations by
Dave S
I am creating a small database to collect labor information on a job by job
basis. I will have the operators logging information into the database using
a...
|
|
4 |
230 |
|
|
Advanced query by
Les
I'm sure this will not be too advanced for someone but I'm lost with it, I'm
using Access 2000.
I have a table with almost 1 million records and 8...
( 1 2 3)
|
|
22 |
364 |
|
|
Query with NOT IN and * by
Shlomit
Hi,
I want to create the following query:
SELECT .., .,
., .
FROM 13
WHERE . NOT IN ('*REQ', '*RA', '*MNA', '*MA');
But I get error from Acces regard the IN...
|
|
2 |
107 |
|
|
Select Query by
bijan
Hi ALL,
please help How can I capture result of this SQL in my Textbox(txt1.value):
SELECT Max(+1) AS Expr1
FROM TBL7 INNER JOIN country ON TBL7.Country =...
|
March 1st, 2007 12:38 PM
by bijan
|
5 |
171 |
|
|
One-to-Many table quey by
kMan
Hello guys,
I have a table, say tblItem, with a primekey. The second table, say
tblCustomer, contains the foreign key to the first table with a 1-to-many...
|
|
5 |
206 |
|
|
GoToRecord Command ... by
Mikey C
Hi all
I have a main form which displays contact details for a particular
person, and then a subform which currently displays the name and
position of all...
|
March 1st, 2007 11:02 AM
by Mikey C
|
0 |
102 |
|
|
syntax in long iif by
Jennyrd
I'm doing a long conditional statement that checks if 2 fields have 0 or 0
values. It must be a problem with the syntax I'm using. Here's my code that
is...
|
|
7 |
162 |
|
|
duplicate vlues by
sierralightfoot
I am using a query as a mail merge source. I have some e-mail address that
are duplicates and I want them to be maintained that way in the table. Is
there an...
|
March 1st, 2007 02:10 AM
by Smartin
|
9 |
171 |
|
|
Reverse Crosstab issue by
[email protected]
Hi everyone,
I am hitting a brick wall!
I have been trying to "flatten" a Table generated by a Maketable query
based on a Crosstab query...
The reason behind...
|
|
1 |
119 |
|
|
Hide Duplicates by
Rzig
Each day I must review a multi-office list of files identified by "Claim ID".
I append these daily lists into one table, then use a query to pull the
files...
|
February 28th, 2007 11:41 PM
by Smartin
|
3 |
94 |
|
|
Run-time Error 3188 Help by
kMan
I'm getting this weird error. Does anyone know what this is?
Runtime Error 3188. Could not update; currenlty locked by another session on
this machine.
This...
|
February 28th, 2007 11:24 PM
by kMan
|
2 |
156 |
|
|
Need Help Creating Database by
nishkrish
Hi,
I am new to access i have a database and need to generate reports based
i=on that, eg. 1 Volume of work in to process.
2) volume of work completed, 3)...
|
|
3 |
186 |
|
|
Today function with a Parameters Query by
john mcmichael
Can Use the the Today function with a Perameters Query. Something like...
between and Today ?
Thanks for the input and have a great day.
|
|
2 |
116 |
|
|
|
February 28th, 2007 10:55 PM
by BossFan
|
5 |
415 |
|
|
|
|
2 |
132 |
|
|
Count names issue by
Flemming
Hi
Thank you for using time on my issue.
I have created a query "quyRoundPrices" that give me the following result
Year Round FirstP SecondP Long ...
|
February 28th, 2007 09:52 PM
by Flemming
|
2 |
222 |
|
|
|
|
3 |
124 |
|
|
IF and mutliple selects by
Dale
Is there a way to do something like an if else so that I can run one of two
selects based on a form field? Something like
IF form!fiield = true
selct...
|
|
3 |
106 |
|
|
|
|
1 |
96 |