Update table data
Mon, 18 Aug 2008 08:33:00 -0700
I create a table that have a column name "CommissionPaid", and three options
selection from a form: 1-Yes, 2-No, and 3-NA. When the data is enter, it
automatically insert into table for, 1 or 2 or 3 (name: CommissionPaid). It
is difficult to understand after awhile what 1, 2 and 3 means after many
radio butt ...
|
Cant eliminate decimals in a query
Mon, 18 Aug 2008 08:16:01 -0700
I have a field in a query that calculates the average miles between two
points. I changed the properties to set it to show zero decimal places yet it
is still returning values with multiple decimal places. How do I fix this? ...
|
Help with summarized query
Mon, 18 Aug 2008 08:07:00 -0700
Hello,
I am trying to create a query to capture the total count in each WC where
the operation corresponding to the WC vary and can be multiple operation per
WC.
The work center ref information is:
WC Operation
Heat 1 to 90
Cool 100
Inspect 110 to 130
QA 140
...
|
How do I setup Fiscal Yr to begin in October in Access
Mon, 18 Aug 2008 07:43:01 -0700
I'm using 2003. I'm trying to set up a query for assessment testing that is
reported quarterly. The FY begins in October instead of Jan. I have the
quarter column set up for the beginning assessment date but it is calculating
from the system's current FY. I have columns for Post Reading Date, Post
Math D ...
|
Comparison Query
Mon, 18 Aug 2008 05:56:34 -0700
My boss is looking for a report to be generated every week to show which
customers did NOT use our services the week before. We do transporting and we
have a drop date field, a billing field, among others, but I am not sure how
to structure a query to show or compare from week to week who give us
business an ...
|
Query and relationships
Mon, 18 Aug 2008 05:09:01 -0700
I have two tables. The first table (table1) has four colums A, B, C and D.
There are 10 records. In the second table (table2) there are 3 columns E, F &
G. There are four records in the second table.
I need a query, that would contain all the ten records from the first table
and add the data from column F o ...
|
conditional appending
Mon, 18 Aug 2008 03:54:01 -0700
Dear all Experts,
I need badly your help in urgent. Pls help me for the problems bellow by
giving me sample codes or proper advice. Pls pls pls help me out ASAP!
Your kind & wise help will be highly appreciated.
Validate the existing date in append query. I have a inventory table where
the whole month ...
|
|
|
Calculate the date interval between all occuring events
Mon, 18 Aug 2008 03:41:01 -0700
Hi,
I have an order table with the number of orders by customers vary. Is there
a simple way to generate a table to show all purchase intervals by each
customer and then be able to calculate the average intervals for each
customer?
Your help is much appreciated.
Regards
Cheryl Lee ...
|
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 ...
|
