query flat file data for most recent data
Fri, 12 Dec 2008 16:52:14 -0800
Annually data is imported from a flat file with one record per student and
appended to the existing history.
I need to determine the value of the most recent value for each subject
areas (blanks are ignored). The 1's indicated met the standard in the subject
and 0's they did not.
Student A needs a report f ...
|
Make Table Query
Fri, 12 Dec 2008 14:55:02 -0800
I have the following query that I run every few months to backup one of my
tables. But instead of "Summer08", I want it to automatically put today's
date so that I don't have to manually change the "Summer08" to something else
before running it. How do I do that?
SELECT TblEnhancedCodes.* INTO TblBackupEn ...
|
Counting records
Fri, 12 Dec 2008 13:39:00 -0800
I havea query where I am counting records in a table and I want
to perform an operation on the table if this value is greater than 1...
In my query, CountRecs_qry, my SPL looks like this:
SELECT Count(*) AS Expr1
FROM TEMP_tbl;
What sort of command do I need to put in my event procedure to check if the
...
|
Combine related table info
Fri, 12 Dec 2008 12:59:01 -0800
TIA:
I have a family table with a family address.
I have related a related family members table with familly member info
Is there a way through queries to end up with a single record that has the
family address from the family table and each family members info in the same
record.
I want to be able ...
|
Creating an Autolookup Query
Fri, 12 Dec 2008 11:02:01 -0800
I want access to automatically fill in several fields based on a unique
customer number that the user will enter. I have a table set up with all of
the information I need to retrieve but I don't know which type of box on my
form I need to use to have access automatically fill in the relevant fields.
If I u ...
|
Re: How to display only 3 letters of a last name in field
Fri, 12 Dec 2008 11:46:00 -0700
On Fri, 12 Dec 2008 10:03:01 -0800, Judy-Court Clerk
<JudyCourtClerk@discussions.microsoft.com> wrote:
>I have 6 lines checked: Visual Basic - MS Access Obj Library - MS DAO
>Library - MS VBA Extensibility 5.3 - MS forms Obj Library - MISSING: MS
>Word Obj Library. I don't see OLE Automation... So, a ...
|
Wildcard Search in Text Field
Fri, 12 Dec 2008 10:15:02 -0800
The wildcard search is not working for the SHOP field in the following code.
I want to search the SHOP field for all strings that contain an A. I have
this code in an Access query. Everything works correctly except for the *
parameter. What is the proper syntax?
IIf([RECFROM]="JOB" And [PROG]="Seattle" And ...
|
|
|
Parameter Queries Using >
Fri, 12 Dec 2008 08:19:02 -0800
Is it possible to use a parameter query using greater than or less than?
I have a few field with numerical data that often require this but not sure
how to buld this into the query. So far I have just been using the between
from and to. ...
|
Date Criteria
Fri, 12 Dec 2008 08:16:01 -0800
I have a table with 5 fields, two of which are dates. When I run my query, I
would like to select between dates. For example, my start date is one field,
and might be 1/1/08, and then my 2nd field is end date, and could be
10/31/08, all on one line in the table, and then the 2nd line may have a
start date ...
|
Parse City State and Zip code
Fri, 12 Dec 2008 08:10:02 -0800
I need some help in seperating the city state and zip code data into 3
individual fields. the data is collected into one column, but our user group
would like to seperate it for reporting purposes and mailing list purposes.
I used the following function to extract the first word before the space in
the c ...
|
