|
Sorting question on an Listbox
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 buttons on other columns.
So if I click on the “backorder†button the list box ...
|
5 |
12/15/2008 7:09:01 AM |
|
|
[acess2003][yupyupxav] Grouping low values in a sum
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:
SELECT DISTINCTROW IIf(Sum(total)>1,designator,"other") AS D,
Sum([QFlights.total]) ...
|
5 |
12/14/2008 7:20:01 PM |
|
|
Access database programming
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 text boxes having null values, placed between the text boxes having
values. I wa...
|
2 |
12/14/2008 6:24:01 PM |
|
|
Can the Column headings in a Pivot Table be rotated vertical like Excel allows?
Can the Column headings in a Pivot Table be rotated vertical like
Excel allows?
My headings are too long and the table is huge....
|
1 |
12/14/2008 6:19:19 PM |
|
|
Query monthly summed account transactions (Simply Accounting)
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 have no transactions in that month.
Here is an example:
SELECT [taccount.lId]...
|
2 |
12/14/2008 10:35:00 AM |
|
|
Leading zeros in text field
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...
|
3 |
12/14/2008 6:31:00 AM |
|
|
subquery help
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,
tblDestinations.[Experience Code Name], tblResidence.Destination,
tblResidence.[Residence ID],...
|
2 |
12/14/2008 4:09:27 AM |
|
|
query flat file data for most recent data
Annually data is imported from a flat file with one record per student and
appended to the existing history.
I need to determine the value of the most recent value for each subject
areas (blanks are ignored). The 1's indicated met the standard in the subject
and 0's they did not.
Student A needs a report for Reading and Writing but not for Writing and
Science, Student B only needs a re...
|
4 |
12/14/2008 12:50:36 AM |
|
|
Combine related table info
TIA:
I have a family table with a family address.
I have related a related family members table with familly member info
Is there a way through queries to end up with a single record that has the
family address from the family table and each family members info in the same
record.
I want to be able to have one table of data to do a mail merge with the
family address and each fam...
|
8 |
12/13/2008 10:04:03 PM |
|
|
WHERE clause for a NULL/Empty field
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
pseudo-code language the task is
IF 3 = NULL OR 3 = Empty then
show records...
|
3 |
12/13/2008 8:41:01 PM |
|
|
Make Table Query
I have the following query that I run every few months to backup one of my
tables. But instead of "Summer08", I want it to automatically put today's
date so that I don't have to manually change the "Summer08" to something else
before running it. How do I do that?
SELECT TblEnhancedCodes.* INTO TblBackupEnhancedCodesSummer08
FROM TblEnhancedCodes;
Thanks!...
|
5 |
12/13/2008 12:31:01 AM |
|
|
Counting records
I havea query where I am counting records in a table and I want
to perform an operation on the table if this value is greater than 1...
In my query, CountRecs_qry, my SPL looks like this:
SELECT Count(*) AS Expr1
FROM TEMP_tbl;
What sort of command do I need to put in my event procedure to check if the
value of Expr1 > 0?
Thanks...
|
3 |
12/12/2008 10:14:58 PM |
|
|
Creating an Autolookup Query
I want access to automatically fill in several fields based on a unique
customer number that the user will enter. I have a table set up with all of
the information I need to retrieve but I don't know which type of box on my
form I need to use to have access automatically fill in the relevant fields.
If I use a combo box, I have to click on each field for the data to be
retrieved. If I...
|
4 |
12/12/2008 9:59:24 PM |
|
|
Loop
I'm not getting the results I need on this loop. I'm trying to check the
value on each sheet in every workbook, and if that cell on each sheet is >0,
then append a 1 value to a table. The code runs, but no value is assigned to
the MasterTbl
For Each sht In wkb.Worksheets
If Range("AF70").Value > 0 Then
SQL = "UPDATE MasterTable"
SQL = SQL &...
|
4 |
12/12/2008 9:55:09 PM |
|
|
How to display only 3 letters of a last name in field
I have a muni court on Access 2003. Judge wants me to print out a list of all
"outstanding balances due" so that any of the other personnel can take a
payment from a defendant when I'm out of the office. I created a query that
works fine but with underage defendants, I have to protect their identities
and many times these are old fines and defendants don't know how much they
owe or what ...
|
12 |
12/12/2008 8:27:01 PM |
|
|
1 query or many?
Hi guys,
I am developing around 15 reports, all of then have a common query, very
detail query, and from this query I generate the reports or generate another
queries that generate the reports, I am going to Splitting the data base to
make it multi-user in this scenario and thinking about performance, what
should I do, keep working with 1 query as the base of all my reports to keep
th...
|
2 |
12/12/2008 5:49:25 PM |
|
|
SEARCH QUERIES VERY SLOW - HOW TO IMPROVE SPEED?
Hello,
MS ACCESS 2003 on XP PRO.
I wrote search panel for my database. I used to have it setup where it
would pull all the data together into one query and then run the criteria
searches on it. that took 2 seconds.
A buddy of mine with database training recommended writing steps of queries,
such that Query1 cuts out some data, Query2 cuts some data out of Query1, and
so on. Thus,...
|
8 |
12/12/2008 5:25:50 PM |
|
|
setting font defaults in windows mail/Vista
How can I set the type face I want as a default; I change it and in the next
email it changes back by itself.
...
|
2 |
12/12/2008 5:21:58 PM |
|
|
PLEASE help with access query
I was wondering if someone could help me with an access query. I'm
faily new to running this type of query so any advice would be
helpful.
Basically, I have a table with three fields, State, Product and
Product Code:
A sampe would like this
state product product code
NJ, Wine, AA,WW,SR,RW
Here is the problem, I have over 4500 records in this database and
product code WW is a pro...
|
6 |
12/12/2008 5:18:39 PM |
|
|
Create EXE
Hello,
I thing this is not the correct news group, but i apreciate any help:
How can i make create a EXE from a mdb?...
Nuno Gomes
...
|
2 |
12/12/2008 5:15:46 PM |
|
|
Very slow query
I have a form with tabs. On one of my tabs I have a subform. The data of this
subform is pulled trough a query. This specific query is bases on 1 query and
2 tables. It takes about 6 seconds to run the query wich is very slow if you
have to browse trough your records.
The query looks like:
SELECT qry_cursist_programme.CURSISTID, qry_cursist_programme.JAAR,
qry_cursist_programme.PROGRAMMAID...
|
3 |
12/12/2008 1:30:45 PM |
|
|
problem with joins
Hi,
I have the following tables
tbl_subrule_tloto
sburuleid ruleid rulemin rulemax
957 11 0 2
958 11 0 3
tbl_rule_values_tloto
ruleid ruleval
11 03
11 33
11 21
957 40
957 41
957 21
957 ...
|
2 |
12/12/2008 12:50:12 PM |
|
|
Help with displaying a count on a form
I have created 2 queries that count distinct project numbers from a table in
my Access data base.
Query1 Called QryCntProject1
SELECT tblProjects.[Project Nbr]
FROM tblProjects
WHERE (((tblProjects.[Actively Reporting])=Yes))
GROUP BY tblProjects.[Project Nbr];
Query2 Called QryCntProjects2
SELECT Count(qryCntProjects1.[Project Nbr]) AS CntProjects
FROM qryCntProjects1;
Then on my f...
|
4 |
12/12/2008 4:32:13 PM |
|
|
Parse City State and Zip code
I need some help in seperating the city state and zip code data into 3
individual fields. the data is collected into one column, but our user group
would like to seperate it for reporting purposes and mailing list purposes.
I used the following function to extract the first word before the space in
the column, however it doesn't work where the city is represented by 2 words.
ANYWHER...
|
2 |
12/12/2008 8:56:18 PM |
|
|
Access 2007 Queries
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?...
|
4 |
12/15/2008 1:45:05 AM |