Access 2007 Queries
Sun, 14 Dec 2008 13:47:01 -0800
I have 2 queries I am trying to run, The first is to get all Units on the
fourth floor only in the query and the first number is 4. How do I do this
correctly. I tried 4, and 4*.
The second one is I need to figure out what 15% of the rate is and I don't
know where to start? ...
|
IIf statement Query
Sun, 14 Dec 2008 11:49:01 -0800
I have created a query on a table: USFed2008TaxRate&Amt and created the
following IIf statement expression for the field: TaxRate in that table based
on the table's Income field. But, I get a syntax error. The data type for
the Income field is currency and the data type for the TaxRate field is a
long inte ...
|
Can the Column headings in a Pivot Table be rotated vertical like
Excel allows?
Sun, 14 Dec 2008 10:19:19 -0800 (PST)
Can the Column headings in a Pivot Table be rotated vertical like
Excel allows?
My headings are too long and the table is huge. ...
|
Access database programming
Sun, 14 Dec 2008 07:57:00 -0800
I have created a bibliographic database using Access 2003. Here some tables
queries, and forms are designed. Some fields have null values. I provided the
codes for invisibility of the text boxes having null values in current view
of the form. But the said form shows the blank spaces in the place of
invisible ...
|
[acess2003][yupyupxav] Grouping low values in a sum
Sun, 14 Dec 2008 15:35:58 +0100
Hello all,
I have a table with a field
designator : text
total : date (where I store a duration, always smaller than 24h)
I want to do a sum by designator, so far no problems but I want to
group small values (here designators with sums less than 24h=1)
i therefore use this syntax for my query:
SELEC ...
|
Sorting question on an Listbox
Sun, 14 Dec 2008 02:54:03 -0800
Hello,
Can someone help please
I have a query build that contains data from al sales list (Partnr.
Description, price, total_sales, back_order etc.) The query sort order is
ascending on Partnr. Results of the query are visible in list box on a form.
What I would like to do is sorting the list box by but ...
|
Leading zeros in text field
Sat, 13 Dec 2008 20:09:01 -0800
Hello! I have a field in a table that is text type. I need to append leading
zero's to the left of the number so that the number is equal to 3 digits.
Example:
001
002
003 ...
|
|
|
subquery help
Sat, 13 Dec 2008 16:32:01 -0800
Hello everyone. Please excuse my ignorance as I am trying to get my feet wet
with SQL. I am trying to run a query that has an imbedded subquery (see
below):
************************************************************
SELECT tblYears.Year_ID, tblMonths.Month_ID, tblDestinations.Region_ID,
tblDestinatio ...
|
Query monthly summed account transactions (Simply Accounting)
Sat, 13 Dec 2008 13:26:06 -0800
I am querying a 2008 Simply Accounting mysql database with Access. I want to
build a simple monthly query arranged by account number showing the sum of
all transactions on each account for a particular month.
My problem is that the only query I can come up with leaves out accounts
that are not null but ha ...
|
WHERE clause for a NULL/Empty field
Sat, 13 Dec 2008 05:18:00 -0800
Hi all! Access 2003.
I'm not able to set WHERE clause properly to do the following:
Field1, Field2, Field3 are all Date/Time fields. 1 and 2 are always filled.
3 is filled only after a precise data that can be , but not necesserily is,
the same of 2. I need a SQL statement tha perform a double check. In
pseu ...
|
