Help with displaying a count on a form
Fri, 12 Dec 2008 08:03:01 -0800
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(q ...
|
Query not returning results
Fri, 12 Dec 2008 06:40:15 -0800
I have two tables ("Volume" and "Class") in a database. Volume is joined to
Class in a one to many relationship. When I run a query, results are only
returned if there are entries in both the volume and class tables. I want
the query to return results from the volume table even if there are not
entries un ...
|
1 query or many?
Fri, 12 Dec 2008 06:35:02 -0800
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 ...
|
setting font defaults in windows mail/Vista
Fri, 12 Dec 2008 09:13:42 -0500
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.
...
|
Create EXE
Thu, 11 Dec 2008 21:33:46 -0000
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
...
|
Very slow query
Fri, 12 Dec 2008 12:56:01 GMT
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_ ...
|
My query is empty. How do I reestabish relationships to add data
Thu, 11 Dec 2008 18:36:00 -0800
I have been using the same database for about 6 years. All of a sudden one
query is empty - no data is in it. Something must have gotten corrupted.
How do I refresh or get the query and database working again?
Other suggestions??
Thank you. ...
|
|
|
problem with joins
Thu, 11 Dec 2008 18:34:09 -0800
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 ...
|
PLEASE help with access query
Thu, 11 Dec 2008 17:49:19 -0800 (PST)
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 t ...
|
Days per month
Thu, 11 Dec 2008 14:29:01 -0800
Hello everyone. I have beed struggling with this for a while but can't seem
to figure it out. I have a database that has two tables with the associated
fields:
tblReservation
- Reservation_ID
- Arrival_Date
- Departure_Date
tblMonth
- Month_ID (1, 2, etc.)
- Month_Desc (Jan, Feb, etc.)
I am try ...
|
