|
|
counting yes/no fields by
Joachim[_4_]
I have an access table where i need to make a query to count the meals they
eat in school in a week for a group of people.
In the query i want to show the...
|
|
3 |
126 |
|
|
|
|
3 |
188 |
|
|
calculate results show funny figures by
KarenY
Hi,
I have to run a qry to get the different value of 2 fields from 2 tables.
Yet some rows come back with funny values for all those minus figures.
(e.g....
|
October 5th, 2009 03:04 PM
by KarenY
|
3 |
131 |
|
|
|
|
3 |
165 |
|
|
Charactor in a string by
alecgreen
Hi
I am looking for a certain charactor (P) at the end of a string, but
the string length may vary, for example 1P, 123P or 12345P
Any ideas...
|
|
1 |
169 |
|
|
Update by
subs
customer dzip New Customer
proctoandg 10024 procto
procto 10024 procto
procto 10024 ...
|
|
3 |
141 |
|
|
|
|
3 |
110 |
|
|
|
|
4 |
189 |
|
|
|
|
3 |
117 |
|
|
Limit Query to Current User Name by
Mark
I'm trying to build a query that will report production stats for system
users, but I'd like to limit the results to the current user. The username
is a...
|
October 4th, 2009 02:01 PM
by Mark
|
5 |
192 |
|
|
Find Records in Identical Tables by
jlo
Monthly I bring in a txt file in Access. What I want to do is create a query
that will take the previous months data and compare to the new months data. ...
|
|
2 |
123 |
|
|
Join not Supported by
vinodh ramadurai
The below query is not working. i am getting error like 'join not supported'
SELECT Tbl_ProductGroupMaster.ProdName, Tbl_ProductGroupMaster.UnitNam,...
|
|
1 |
98 |
|
|
In clause from form by
QB
Is there a way to setup a cbo ctrl to be used as an In clause within an SQL
statement?
I set one up
In (!.)
Where my cbo returns value like 'Open' and...
|
|
4 |
127 |
|
|
|
|
2 |
111 |
|
|
blank fields on a report by
DKnight via AccessMonster.com
Hi,
I am trying to run a report and I have four address lines. On the report,
if the first address line is blank, I would like to print the second address
in...
|
|
7 |
122 |
|
|
Using query to make a table by
Jael
I have a table that's linked to a xxx.cvs file. I use a query to make a new
table with modified data in it. The first time I use the query, it works
fine. ...
|
October 3rd, 2009 05:11 PM
by Jael
|
5 |
127 |
|
|
Access 2002 SQL Problem by
johnb
Hi all
I have the following SQL code snippet and it produces the incorrect number
of records when its run by Docmd.RunSQL strSQL, but the correct number...
|
|
1 |
124 |
|
|
Count not right by
QB
I have a table that I am using to generate a pie chart from by counting the
number of instance of in a column. However, to always display all the
choices,...
|
|
1 |
98 |
|
|
Creating a month field by
mccallen60
Hello,
I receive a monthly report of total prescriptions processed from a
independent vendor. This report utilizes a rolling 24 months.
TRx Month24 TRx...
|
|
3 |
99 |
|
|
What's wrong with this query? by
vvenk
I am new to SQL and your help is very much appreciated.
The Table VISIT_TYPE has a o-M relationship with PATIENT_VISIT.
I am trying to update the fields,...
|
|
6 |
152 |