|
|
Current Date, MTD, YTD, Last Year's MTD by
Gina
Say I have a date (05/29/04). Using this date:
How do I get the MTD date range (which should be 05/01/04 -
05/29/04)?
How do I get the YTD date range (which...
|
|
3 |
627 |
|
|
Undefined function 'Date' in expression by
Doug
I get the above error message when I use Date() in a query criteria to retrieve records. This used to work in access 97. I am very dependant on being able to...
|
|
2 |
636 |
|
|
sql view by
charles osborne
Does anyone know why the SQL view may not be available to
use for a table of form? I have read that you can get the
SQL view by clicking on the view button...
|
|
4 |
880 |
|
|
Expression (Checkbook) by
Tom
Just like in a checkbook, I want to create a query that contains 1 field
plus 1 expression:
- Expenses (field)
- Remaining Balance (expression)
Naturally, I...
|
May 29th, 2004 02:38 PM
by Tom
|
0 |
444 |
|
|
|
|
6 |
717 |
|
|
|
May 29th, 2004 01:48 PM
by Jonas
|
2 |
427 |
|
|
Can Access make a transaction query? by
Christina
Hi There,
I am wondering if Access can do a transaction query like
SQL server. For example, I'd like to insert records to
serveral tables, if one insertion is...
|
|
2 |
332 |
|
|
|
|
2 |
755 |
|
|
IsLoaded by
Maureen
I have copied the IsLoaded module from the Northwind DB
into my own DB. I have successfully used this code in a
macro condition.
Can I use the IsLoaded...
|
|
1 |
324 |
|
|
Compare multiple fields in record by
Can
I have 5 different date fields in a record, I need to
compare them to see which date is the most current. Some
fields may be null.
I have a module, then I...
|
|
1 |
563 |
|
|
|
|
2 |
486 |
|
|
|
|
3 |
754 |
|
|
Query with multiple fields and one form by
Evan McCutchen
Hello,
I have a database that has a form "Bluebook" and a corresponding table
"Bluebook". On the form, i have a button that says Query and when clicked,
it...
|
|
1 |
806 |
|
|
What is wrong with this WHERE clause ? by
David
WHERE CloseDate is not Null AND
CloseDate Between "#" & Format$(varStart(), 'mm/dd/yyyy hh:nn:ss AM/PM') & "# And #" & Format$(varEnd(), 'mm/dd/yyyy hh:nn:ss...
|
|
2 |
251 |
|
|
Select vs update Query by
Joyce
I'm trying to create a form that I can use to update
individual records. I created a select querty to identify
the record, but I can't seem to update the...
|
|
1 |
664 |
|
|
Union Select sorting by
JR
I'm having trouble sorting a Union Select query. I would like to sort on a hidden field, but from what I've read in help the only 'order by' field that I can...
|
|
2 |
334 |
|
|
|
May 28th, 2004 11:31 PM
by Looney
|
4 |
525 |
|
|
Adding Up Hours by
Jackie
I need to track the number of hours a student accumulates
while taking various courses. These hours will then need
to be added, by query, to produce a total...
|
May 28th, 2004 11:29 PM
by Jackie
|
2 |
336 |
|
|
Last functions in Total Row by
Jordan
The way I understand these functions, they will return
the last value entered chronologically from a group of
records. So if I have a autonumber field in this...
|
|
5 |
271 |
|
|
comparing multiple fields by
Fish
I am trying to compare a database with a dept. and shift field to another database with that has the same two fields to see if they match. It will then return...
|
May 28th, 2004 10:00 PM
by Rick B
|
1 |
366 |