|
|
Date and Parameter question. by
Dan
Hi I am having a problem in a query I am trying to pull. I have a date feild
that I am querying and in the criteria I have this.
=Date()- when I run this it...
|
|
4 |
203 |
|
|
Delete records by
pdehner
I have a table called residency
I create a query (named notdate) that uses the residency table and compares
to another table. I want to take the results of...
|
|
5 |
252 |
|
|
Parameter Query by
AccessUser777 via AccessMonster.com
Hi All,
Here's what I have:
TABLE1(tbl_MAIN_DISC) with the following fields:
DISC_ID=PK
DATE
USER_ID
USER
DISC_TYPE_ID
DISC_TYPE
|
|
3 |
286 |
|
|
multipling by
Norm
I have a field.. SumOfPHCTC..and I want to multiply this by a value that I
can enter..the value will be different each time ...SumOfPHCTC...changes each
query
|
|
3 |
156 |
|
|
Query Too Complex with Total line by
kratz
I've had this query working in the past, but I made some adjustments, and now
the query is too complex.
I am trying to group/sum per agent number per...
|
December 21st, 2009 04:14 PM
by kratz
|
8 |
231 |
|
|
This query not giving correct results by
Bob H[_4_]
I am trying to find the date when we had the most rainfall out of 3234
records, so with the first query to get the maximum rainfall in a month
I get 110...
|
|
4 |
163 |
|
|
Help Needed on Complicated Query by
boooney
Hi-
I have a database that has a number of projects and suppliers for these
projects. Each project has several contracts being supplied by several...
|
December 21st, 2009 04:36 AM
by boooney
|
1 |
441 |
|
|
using a rolling date range to sum by
reluctantcoder
I want to use an update query to sum values of the previous twelve months. I
tried using
BETWEEN "#" & & "# AND #" & & "#"
in the criteria to limit...
|
|
2 |
186 |
|
|
1 Field and 2 Criteria by
jace
I'm new to Access but very fluent in Excel so bare with me on this.
What I have is a query I'm trying to create where I have a Problem
Code(numeric) and a...
|
December 20th, 2009 11:01 PM
by jace
|
2 |
140 |
|
|
Microsoft Query by
brucemel
I've been told to download Microsoft Query add in so I get minipulate some of
my data in Simply acctg. I can't find it as a download on Microsoft's site.
Is...
|
|
1 |
150 |
|
|
Parametery Query by
T. T. T
I have built a report based on a parameter query. I have a field in my
report that is a calculation( Availiable Spend: Format(*2) ).
Instead of...
|
|
3 |
278 |
|
|
max for each person by
geebee
hi,
need to select the MAX centername for each person (determined by combining
date. and centername AS ID) , and join that to another table by the created...
|
|
1 |
164 |
|
|
Indentifying a payperiod by
KWhamill
I want to Sum the number of hrs A has worked in a pay period. I have a chart
that gives me the start and end date of the pay periods, and i have A's work...
|
|
2 |
170 |
|
|
select every 100th records by
pdehner
I have numerous tables in one database that I must select records to send a
survey to. I would like to select every 100th record an export results to an...
|
|
5 |
150 |
|
|
SQL Code Help by
[email protected]
Hi,all
Could someone help me out with some SQL code to resolve the following issue?
I need to generate one piece of SQL code to be used by a report via a...
|
|
2 |
117 |
|
|
|
|
0 |
180 |
|
|
Update type conversion error with nulls by
DonnaJN
I need to simply divide one currency value by another currency value. Sounds
simple????? Here are two sql statements I've tried. Most records are null,
it...
|
|
3 |
188 |
|
|
|
|
6 |
228 |
|
|
If then statement?? by
Schon
I am new to Access and am trying to take a field and change the value
depending on what the current value is. example
If is 01 then "supplies", if is 02...
|
|
2 |
128 |
|
|
Sumif function in Access by
Hurrikane4
Please help!
I need to sum amounts if a condition applies.
The source table has 3 columns:
AcctNum, Amount, Category.
123 10 Tax
123 5...
|
|
2 |
157 |