I have a table with a field >0 and <99999 (decimals are allowed).  And since
I have to export this table to a fixed-width ACII file, and this field has to
be length of 5, I created a query and tried to use
"newfieldname:round(oldfield name, 5) to make the length of the filed = or ...

Is there a way to automate the running of an Access Query?
I would like to schedule this "job" (query) to run automatically every
Monday morning at 7:00.  Can I do that in Access?
Thanks

Hello,  I am creating a database that will be used to track janitorial
duties.  Each duty is performed once a week by a certain person on a certain
shift, and almost every day has more than one duty/person/shift combination.  
I have created the tables, forms, links, and a great ...

I have a query where the field is male/female. male = 1  female =2. In the
results, I want to display the term male instead of 1 and female instead of
2. Is there a way to do this.

I wonder if someone could help me please.  I have an Access 2000 database
which needs to create a temporary table and then later delete it again (lets
call it 'tableA').  Is there a way (in VB) of checking whether the table
exists before executing subsequent code. 99% of the time it ...

Would someone be able to help me with VB code to achieve the following?
I have a *text* field in a table that holds four values; 9, 10, 11, or
12.
I'm trying to write a query that will update the 9 to a 10, the 10 to

I have a table containing persons and another which has personexpense.
I would like to create a query which does a total for expenses for each
person. How can I do this?
Thanks

I wish to determine what beds are available on a user specified date. I can
query a specific date [Requested Date(dd/mm/yyyy)], however I can not get
anything more than results of the beds booked on that date, whereas I would
like that data PLUS results showing which beds were ...

Here is the scenario. we have a few thoushand items that are grouped into a
few dozen categoreis. I need to write a query that will return the top 25
items by sales for each categorey.

I have a report that simply gives a count of separate categories by
[enterdt].  I would like to amend that report to make sure that for each
category, i have a count of account numbers which were in the population the
previous day.  for example, for May 10, if there were 458 ...

I have this expression to find the number of females, it totals 338 but 67
of the count is dups or trips of the same female number. the count should be
271 if I can exclude the duplicates and triples.
Total Females: Sum(IIf([MaleReport1]![WHELPING DATE] Is Not Null Or

I have this expression
Total Whelped Females: Sum(IIf([MaleReport1]![WHELPING DATE] Is Not
Null,1,0))
It gives me the sum for each record, which there are 54 records and the

Can someone tell me how to query 8 tables with a common, not primary
key, field of Emp#?
My tables cant have a primary key because of duplicates. If someone has
an idea how I can fix my problem I would be grateful. Example of 1

From the database of all students, I want to count the number of students who
have attended classes in any of the last 4 terms, without duplications (some
students have attended more than one term.
My query includes student ID# - Active Attendance - 2005 OR 2006 - Summer OR

I need to look up part of a word againts a list of words.
Example:
- Table 1 contains a list of keywords:
Keyword 1 = Smith