Hi basically i was wondering if you could have more than 1 case in an
update query.
For example:
if field x is null then update to y however if x is not null update to

I apologise if this is a silly query, but I have the following issue.
I made a database and have a form for Adding data. This has the "allow
filters, allow edits, allow deletions, allow additions and data entry"
settings set to YES. Works fine.

I have a table with several hundred records. I have a numerical field with
different values that I want to sort. I want to run a query that shows only
ranges not all of the records. For example, how many records with a value
less than ten, how many with values 10-20, and how many ...

   This is embarrassing because I know this has to be very simple but
I'm just not getting it so --
I have a single, detail table.  One field is (serialnoFK) a foreign
key to a different table. Another field (outdate) is an activity date/

I have several queries that are based on a set of queries that I can't see.
The queries based on those queries mostly work, but I can't get at them for
troubleshooting.  Yes, I have the view hidden objects checkbox checked, but
I'm certain I never hid those queries.  What else ...

My database tracks all of the staff development sessions provided for the
past ten years, thus we have thousands of records.  Our school district
wants all departments to move away from using an employee's Social Security
number to a number assigned by the district.  Each ...

I am in a pinch for a solution to a calculation that uses a zero for the
default value in the fields that do not have a 1, 2, 3, 4, 5 or 6 in them.
This is the sql code:
SELECT tblClassEntries.PlaceJ1, (7-[placeJ1]) AS Points,

I am running a query where one of the fields I'm trying to print is called
EmpNum.  When I run the query, the resulting field name is changed to
Expr1000.  Can anyone tell me what is wrong with this query?  I have looked
in the posts and am not finding any hits.  Thanks for your ...

I need to add ranking to a table of values, and even through I've gone
through everything in the group, I can't pinpoint my problem.
Here goes... I have the following resulting query
 Date     MeasureID     Store  Perf

I have a field [dte1] with date-like text. I created another field ....
EventDate: DateValue([dte1]). It works great. I made the Event Date a long
date and I get a long date; I make it a short date, and I get a short date.
HOWEVER, when I try to put >date() in the criteria, I get ...

Arg!
I have a date field in a table: MembershipLetterDate
I have a subquery on a different table that contains:
Membership Expiration: Max(DateAdd("d",365,[DateCreated]))

Table tblRoundAwards have the following fields
ID, RoundID, YearNo, StablefordPoints1, StablefordPoints2, LongDrive, Par3,
Par4
Table tblPlayers have

Hello, each day I need to get the previous days data from MS SQL table
into a .csv file automatically. Has anyone done this before in a
script, or can point me in the right direction of how to start this?
I have been working on the query below to get the previous days data

I need to append all of the records from table A to table B. Any help would
be appreciated.

I'm using a form, that is not attached to any table or anything, as a place
for a user to enter criteria for a query rather than having them go into the
query itself.  The user enters criteria in such fields as 'State',
'EventDate', etc...