Hi, there is a batch program that runs everyday...each record has a field
batch_no which is populated everytime a batch is run. for example lets say
Day one is D1, day 2 is D2 etc. what statement would u use to grab the
records with the latest batch number? I am doing it in ...

I have a query that returns a set of data. I would like to add a field in
that query that automatically calculates a sequential number for each record.
The number should increase incrementally by 1 and start with 1
I am just trying to number the results exactly how they are shown ...

Greetings All,
I have set up a query to use for a report.  When I "drag&drop" most of
the fields from the table, they look the way they do in the table.
But some get brackets around them in the query.  I can't see any

Access 2003
I have been running into an issue in the past few days that has been
puzzling me, and I have not been able to find a reason for it. If I use VBA
code to set a date value on a table, the value that gets saved to the table

I have a query where I need to total two numbers that are inputted
from two other queries.  What I mean is that lets say under 65 has a
12 and over 65 has an 8 then I want a total to show 20.  Here is the
SQL of the query.  Please can anyone help me.

I am not sure I post this in the right place. Anyway, I like to perform Find
and Replace in Access Table. Sometime, I imported data with blank into table,
and Access treats this empty field as Null, not Zero. How can I perform Find
and Replace these Null data field with something ...

I have a table with 2 fields:
server
vss
Now I need to create a form that show me the vss based on the server

I want to change the nulls to zero in my Crosstab query only when the column
name (Project) has the word "rework" in it.
The following SHOULD work:
Expr1: IIf(InStr([Project],"Rework"),Nz(Sum([hours]),0),Sum([hours]))

Hello.  This is the second time I've posted this.  The answer I received
prior is not practical.
I'm using Access 97.  I have a query used to export data to a .csv
file.  The issue our users have is that Excel confuses some of the data and

I have records in my Access Database Version 9.0 with these basic fields,
LName, FName, PtNumber, AdmitDate, DCDate.  The Names and PtNumber are
already entered and there are 2000 records.  Each week I get a report that
has all of our dicharged patients with many fields including ...

I have a database that I'm using to pull the names of students who
have applied for graduation from an Excel spreadsheet, that is updated
weekly, into an Access Table. Right now, I'm using an unmatched query
to pull Student IDs who have not previously appeared on the Excel

For the US among others the decimal symbol is a dot. Many countries, mine
with them, is using a comma instead. Now, when performing an SQL query with a
decimal number as an argument with the decimal symbol being a comma, the
query will fail: "Syntax error (comma) in query ...

I need help to built a queries into MS Access.. The queries i want to
built should be someting like this...
SELECT mtblRequest.refNum, mtblRequest.Date, mtblRequest.CSRName,
mtblRequest.Office, mtblRequest.TL, mtblRequest.ATL,

I have a spreadsheet that I import into a database.  One of the columns in
the spreadsheet gets imported into a combo box (I want to limit the
selections available because of the reports that I have).  Unfortunately,
there are too many things that can be written into this field.  ...

Good Evening Everyone...
I have a bit of a logical puzzle that I need to solve.  I have various
queries which have various criteria for them.  One query involves
retirees or spouses being under the age of 65 and the other involves