Hi there, I've got another tricky problem.
I have a table with 5 columns. Columns are called 1, 2, 3, 4, 5.
One case:
Columns 1 and 3 have numbers in them. Columns 2, 4 and 5 do not any

I have been told to create a new query and change it to an update query.
Refer to my question Can I sort database by year/month/day17/11/05 maud0361
answered by Allen Browne. I don't know haw to do that as I cannot find a menu
with this option. I am using Access 97

Hello I have a Query in a function that summarizes a pretty big table
in to summary tables in SQL Server.
With my current knowledge of Access I can't pull this off. Im not sure
I can use a case statement  Ex.COUNT(CASE DIRFMINT WHEN 'N' THEN 1 ELSE

I have a query which pulls out payments made depending on a date parameter
given. Then I have a report based on the query which sorts the payments by
where the payment was received. I need a total of payments received for given
date for each location. Where do I put the Sum ...

Universities want to create or change queries in our Access database from a
web page so they can see our best students academically.  
They have informed me it can be done in Linux.
After they create or atler the Query, we will create a report from it in

I have a table that has unique records. I received a file from users to
delete some records. How can I do this? I don't want to type the record Id on
the Query criteria, because there are hundred of records. I want to match
both files by record Id and if there is a match then ...

I have a field called AcctgMonth with 2 columns (combo box: column 1 = Jan
...till Dec; column 2 = 01... till 12) and I have an expression for users to
enter month (mmm), it works out fine to pull out the data pertaining to the
entered month.

I am going to try and explain this as best possible. My database is for
Accounts Receivables. We assign new customers a company number, we have 7
Branches, each Branch has a number range between 00001 thru 9999. At the
moment they are assigned randomly. I need to track numbers ...

I have a table that lists all patient visits (Patient names & ID
duplicated).
Can anybody advise how I can:-
1) Remove all the records where the field name "ChartNumber" begins with the

by pressing one button am running 3 update queries that would update 3
different fields in 3 different tables at once and would not like to the
warning that you about to update 3 records three times, however I would like
the user to be informed that the following [Fields] in the ...

I get a text and import into a Access table. Several of the fields contain
dollar amounts that are in this format; 100023. I need to update these
fields by inserting a decimal point two places from the right and a comma
separator. I am importing these fields as text as they are not ...

I'm using office 2003. I know it is possible to name a field, then use that
field for a calculation within the same query. I've done it before. I have a
new query, and it isn't working. Can anybody tell me why. Let me give an
example of what I mean:

I am putting citeria in a query for a table. The table has values associated
with dates that are both less than and greater than today.  I would like to
set a criteria that says, "If there is a date that is greater than today then
return the value for that date as well as a value ...

I work for a publication that wants to keep track of all our stories, the
category they fall into, and the area of town that they cover. I have created
a simple table with all of the stories, categories, and areas, along with
other information (date, etc.) My problem is that some ...

Has anyone written a formula that counts the number of work days (mon-fri) in
a given month?