Search command
Mon, 18 Aug 2008 06:23:01 GMT
Hi,
Pls, anyone can help to me? I want to create search command for staff
attendance.
E.g Department name = SALES
Staff name = KELVIN
Start attend date = 1\08\2008
Last attend date = 15\08\2008
Then click search command button!!!
I am really apprecite your helpfulness.
Regards ...
|
incorrect Rounding MsAccess 2003
Sun, 17 Aug 2008 08:22:01 -0700
In a query I use the following expr1 for calculating text fields
round(val(field1)*val(field2);3)
Issue is that in not all cases does it round correctly I have one calc where
the result without rounding = 5.7865 With rouding I would expect the result
to be 5.787 but in this case the resut is 5.786
Anyone any ...
|
records for the year
Sat, 16 Aug 2008 13:08:10 -0700
I have a table/ form that i record employee accidents in, with fields - Ref
No, Name, Accident type, Date details recieved. The accident type field
choices are:- B = blameworthy, N = No blame, P = Part blame, so with a drop
down you select B, N or P. What i need is a query that i can use to give me
the numbe ...
|
Plugging todays today into Table Name
Sat, 16 Aug 2008 20:00:57 +0100
I use the following query to generate a list of addresses to mail to. I'd
like to be able to put the creation date into the name of the table (e.g.
INTO [20080815 FCP S1 Postcards to Send].) I realize I could do this
manually every time I run it, but I'd like to be able to do it
programatically. If this ...
|
finding location of ODBC source in Access
Sat, 16 Aug 2008 10:55:01 -0700
Is there a way to list/display the source location/properties of an ODBC link
in an Access DB?
An Access MDB was backed-up before a computer was re-imaged
I'm trying to find information on the ODBC source location to re-establish
the links in the restored MDB so it will work
I got this great query from th ...
|
trim function
Sat, 16 Aug 2008 10:06:01 -0700
I have a table with 80 columns in it that I imprted from another program.
Aside from doing each individually, is there a way in an update query that I
can trim all fields at once?? ...
|
Merging four fields into one
Sat, 16 Aug 2008 08:22:00 -0700
I have the follwing SQL:
SELECT tbl_Points.Run_No, tbl_Points.LeaveBy1, tbl_Points.LeaveBy2,
tbl_Points.LeaveBy3, tbl_Points.LeaveBy4
FROM tbl_Points;
and want to merge
LeaveBy1
LeaveBy2
LeaveBy3
LeaveBy4
into 1 column, [Leavy_By]
so that I just get 2 columns:
Run_No, Leave_By
Run_No, Leave_B ...
|
|
|
opposite of inner join; exclude rather than match
Sat, 16 Aug 2008 07:51:01 -0700
Essentially, Iâ??m trying to do the opposite of an inner join, to exclude the
values from table A that have matching values in table B, returning all the
other records from Table A, rather than return the records that exist in both
tables.
Using the text below as an example, an inner join of Table A to Tabl ...
|
Formatting Telephone Number Question
Sat, 16 Aug 2008 05:59:00 -0700
All,
I have a database with a telephone field with format of:
555-555-5555
I need to format this field using a query to be:
5555555555
Can any one help with a format expression..
Thank you in advance,
Brad
...
|
Testing for null
Sat, 16 Aug 2008 01:21:01 -0700
My query was getting unpredictable results.
I think I found the source of the problem.
There is field that contains some empty values in some records.
When I test the field for nulls by creating a calculated field in a query
with the expression
IsItNull: IsNull([Field1])
For the records where the field is ...
|
