Our pay period includes the 25th of the current month
into the 24th of the following month.  How do I group
dates so that when I slice my data by month, the
appropriate dates are aggregated?  For example, I want to

I have a column called ProductID, I also have another column called thumb_image with a default value of ../images/gif/   and then I have one more column call full_image with a default value off ../images/jpeg/
I need to have the productID data be displayed after the default value ...

I'm a newbie and I've a simple question: I've a calculeted field (pupils
age) in a form and I want to store that value in a table. How to do this?
TIA
Arlindo Fragoso

Is there a way to permanently change the default value for
numeric values so that when setting up a new table I won't
have to do this for every numeric field?

I split my database but know we need to put it back to what it originaly was.
How do you do it?
I deleted all the split tables and then imported the tables back but know it accesses the tables very slow.  What did I do wrong?

I'm wondering what is the best way to do the following.
I have 2 tables, InternalOrders & ExternalOrders  one of
the fields is the same in both tables.  "Status"
So the following:

I want to add the current month to my table each time a record is added so I
can query by calendar month is this possible if so how I can add whole date
but am unsure how to then set up query to only return info for that month ??
and help would be great

I have form that does a name lookup from a linked table.  
Once I lookup a name I would like to then click a submit
button which would input that data into a separate access
table.  Can anyone lead me in the right direction on how

In a table or query, is there a way I can force it to
always round UP to the nearest whole number (1.1 would
round up to 2)?

Anyone Know how to Change Table field captions using VBA
code.

I have been trying to figure this out myself but just can't figure out the best way to track employee availability.  Employees dictate their schedule so I need to capture daily availability along with a start time and end time for each work day they can work.  Any suggestions on ...

Does anyone know where I might get a list of States(US)
and countries of the World that I can pull into a tracking
database I'm building.

Is there a way to change the line color so when someone
opens a table the color of each row alternates (say
between yellow and white)
in other words the row would go

I'm having trouble with something that should be simple:
I have a project with committees for each project.  I want
to be able to select people from a db to have a list of
many people (a committee) for each project.

When I append one table to another through a query I am
losing data in some of my fields.  I'd like to know why
this is happening and how it can be prevented in the
future.  Any suggestions? Thanks in advance.