I have a list of 1000's of products that I would like to categorize based on
their names.  I expect to have about 50 categories and prefer not to have 50
different update queries.
What I have now is:

I am stuck with a date function, I think it is just something silly I am
missing, please could you advise.
Many thanks for your time.
Kerry

In creating the following in SQL I am getting the following error "invalid
bracketing of name"...  As I look at this
SELECT [Beginning Transaction Date] AS Expr2, [Ending Transaction Date] AS
Expr3, [Manual check].[PaygroupLookup] AS [Business unit],

I have the following relationships:
tble_query -> 1:n -> tble_Ccode <- n:1 <- lkup_CcodeS <- n:1 <- lkup_CCodeT
I have a form which holds "query" information and I have a subform which
holds "CCode" information. The subform consists of a cascading combo that

I have a query that I output into a report. When I use the sum
function in the report control source property field I get a mismatch
error when I run the report.
example

I'm using access 2000. I am trying to set up a form that will change the
criteria in a query to show whatever has been typed into a text box on the
form. I have successfully managed to link a parameter query to the form,
however I would like the "search" facility to change the ...

i have a query like this
idno    haemoglobin
1        10.2
2         14.6

I have three tables (Employees, Outsourced and Projects).
Projects table include
project_id,
project_name,

In one of my calculated fields, I am trying to reference another calculated
field within it:
EMPIDValidation: IIf(Len([EMPID])<>0,[EMPID],(Select A.EMPID FROM
tblInvalidSINMapping as A WHERE (A.InvalidSIN = tblPayrollUpload.SIN) AND

PAYDATE: (SELECT ????([DATE]) FROM [TABLE2] WHERE [TABLE2].[IDNO] =
[TABLE1].[IDNO])
i want to set the the earliest date record from other table to my query but
i do not know what is the correct expression for this can any1 teach me how!

I have a query that groups records by Client and uses the date entered by the
user which all works fine, but I also want to show the last entered date
prior to the date entered by the user for each client that has an entry on
the date entered by user.

I have the following expression in query "Deposits3" under field [Office
Name], table [Deposits] for the report "rptDeposits3":
Trim(Str([Offices]![OffName]))
What I'm trying to do is link the shown table [Offices] field [OffName] to

We need the Code from Queries or Forms or Reports or Modules in Microsoft
Access 2003 to distinguish between last record of the last month and least
record number in the following month.
Then compare both of the records and then give as the least (less) figure

Each year before March 31, I prepare a text file for the IRS reporting
center that has specific formatting rules. In the past I have been able to
"export" the data from an Access query to a text editor by completing an
"export wizard" that was part of the Access export procedure.

I have come across this little requirement for a database that I am writting
and I hope that someone could give me the answer?
I have a qury providing a calculation, but I need the answer to always round
up to the next whole number.