|
|
current month by
rml
What would be the proper syntax for a query to return the
records for the current month? I would like it to work
like date() but for the month.
Thanks.
|
|
1 |
354 |
|
|
How to 'Count' Multiple fields?? by
Ben Johnson
My database needs to run a report that will give the total number of
each specific type of inspection given a user-defined date range. I
have about 15...
|
|
3 |
384 |
|
|
Code to search 'any part of field' by
AMH
I use a form to search a text field in a query
The SQL view of the query looks like this
SELECT qryMainRefList.YR, qryMainRefList.TI,...
|
July 11th, 2004 02:55 PM
by AMH
|
3 |
349 |
|
|
Start query from 01-01-year(date() by
Harmannus
Hallo,
How can a i use 01-01-year(date()) in my query for date calculation.
e.g. = 01-01-year(date()) and =DateField
Tried "01-01-"&year(date()) but that...
|
|
2 |
115 |
|
|
Variable dates in queries by
Steve
I run ten queries each week , each of them has a variable
(date) that needs to be changed before i run the query.
This means that I have to go into each of...
|
July 11th, 2004 03:05 PM
by Steve
|
3 |
156 |
|
|
|
July 11th, 2004 04:57 PM
by fredg
|
1 |
97 |
|
|
Using a query result in an expression by
Phil Hood
I have a query that checks to see whether a record already
exists in a particular table. The result if it does is
that Expr1 = -1
My question is how do I...
|
|
2 |
532 |
|
|
|
|
3 |
2,111 |
|
|
|
|
1 |
153 |
|
|
totals between two dates by
beppe005
I have a query with the following fields: date, invoice, client, expenses,
hours.
I need to know the total of the invoice (and expenses and hours) between...
|
|
3 |
134 |
|
|
How to ignore fields in Update Query by
Casa
Hi everyone
I have two tables. All incoming data goes into Table A. Table B are certain records from Table A. What happens is that some data goes into...
|
|
6 |
698 |
|
|
Weird Access INSERT INTO Query error by
Macca
Hi all,
This should probably go into the .net newsgroup as well.
I am using an Access 97 database (I have no control over this - it is part
of a package...
|
July 12th, 2004 01:47 AM
by Macca
|
5 |
566 |
|
|
|
July 12th, 2004 02:51 AM
by Bob M.
|
14 |
532 |
|
|
calculated fields by
chip Goodaker
I want to add a calculated field to a table. In Excel I
simply write a function: (i.e. add three columns and
write the result in the fourth). Apparently it's...
|
|
2 |
369 |
|
|
Date Format HELP by
John Vercelletto
I know this is probably and easy one, I have done it
before, but blanking out now.
I have a date/time field (DateShipped) and I am creating
a query from the...
|
|
3 |
116 |
|
|
|
July 12th, 2004 07:48 AM
by eddiec
|
3 |
512 |
|
|
|
|
2 |
118 |
|
|
Avoid #Error Value In Query by
Roy
I Got a Query that is Calculating the True Average of the 5 Days of the Week by Product.
What happen is, some products can be 0 at the end of the week(Product...
|
|
1 |
129 |
|
|
Union Query Issue by
Larry
Hi guys.
I'm using Access 97 (SP2) to do some work for a client.
I am running a Union Query on two tables tht are identical, to create one
set of data. Here...
|
July 12th, 2004 08:53 AM
by Pete S
|
4 |
926 |
|
|
syntax error by
JT
I am having trouble with criteria in my query. I'm trying
to use an expression but keep getting a syntax error. The
expression for the GroupID field in the...
|
|
1 |
468 |