Sir, I would like to make a bank statement and having problems in calculation
because when i m calcualing it calculate whole field not record wise
please help me in this regards
Thanks

I have a input table  as follows:
UserName   Action   ActionTime   FirstLogOnTime           LastLogOffTime  
User1          Logon   10:04:24     10:00                           19:00
User2          Logon   11:07:04     11:00                           20:00

I have a input table  as follows:
UserName   Action   ActionTime   FirstLogOnTime           LastLogOffTime  
User1          Logon   10:04:24     10:00                           19:00
User2          Logon   11:07:04     11:00                           20:00

I want to limit the number of records showing for
individuals with multiple Addresses.
Following is my table structure.
tblARTISTS        tblADDRESS_TYPE      tblADDRESS

Description
I am having problems creating an updateable query to base a form on.  I wish
to have a continuous form displaying various envelopes we hold in stock for
any particular customer. Obtained from customer table, stock items table and

Table has a field with Date/Time data type ( 09/08/2005  21:45:35 format).
I need to separate its Date and Time portions into two fields (Date Field
and Time Field). How Can I do that? Later I need to combine them again. How
Can I?

I have a query that uses in the criteria section, text boxes from a form
text box names on the form values are:
Name
Date From

Table has a field with Date/Time data type ( 09/08/2005  21:45:35 format).
I need to separate its Date and Time portions into two fields (Date Field
and Time Field). How Can I do that? Later I need to combine them again. How
Can I?

I have two tables, Client Info and Client Visits. The first table has
general info that does not change so Client info is entered one time only.
The
second table records services provided at each client visit. The first table

I am trying to put most of my functions and procedures in an external MDE
and reference it through the library.  I can seem to see the reference for my
external MDE library in the code window and can access it by using the syntax
library.Module.function.  However when trying to ...

I have database, the purpose of which is for students to book a date and time
for a test.  Tests can only be taken at the following days/times and last
45mins:
Mondays: 11:30 to 12:30 and 12:30 to 13:30

I have a simple table to record a range of jewellery with an image for each
variation. The fields are Item, Pattern Number, Stones, Image (Picture). e.g
Brooch, 100A ,Coral , Picture.
There is no unique field because a particular pattern number could relate to

Field [Address]
1234 Anywhere St #29
34 Anywhere St #345
1 Anywhere St #1

I have a table with birthdate of persons
I would like to write a query giving me all anniveraries coming up within
one month from now.
Can someone help me with this?

For a union query of two tables, is it possible to include the name of the
table as an additional field for each record, so that I know from which
table a record has come?
What would be the sql code to do that?