|
|
unable to run the query by
Niroshana
I have upsized my Access 2007 database to SQL server 2005 database (Front end
Access Database and Back end SQL server Database). Following MS Access query...
|
|
2 |
261 |
|
|
Trouble shooting a query by
Brigid
I have a database which collects sales for a company that sells burrito's.
We deliver a certain number and a certain number is wasted. The Difference...
|
|
1 |
190 |
|
|
Displaying Yes or No rather than 0 or 1 by
Jerry Anderson[_2_]
I have a query that includes a Yes/No field. When it displays the results in
a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this...
|
|
1 |
198 |
|
|
wish there was a CountDistinct() function by
h2fcell
I have to create a query that counts the number of DISTINCT Agencies that
contribute to the sum of GrossSales grouped by Division.
The follow query returns...
|
|
6 |
202 |
|
|
MS Access Query criteria Problem by
Niroshana
I have upsized my Access 2007 database to SQL server 2005 database (Front end
Access Database and Back end SQL server Database). Following MS Access query...
|
|
2 |
176 |
|
|
Add % to Existing Number by
Hari[_2_]
Hi All,
How can show my filed with rounded number and with % in other field.
ex (0 = 0.00%
0.1 = 0.01%
2.5555 = 2.56%
5.666777 =...
|
|
1 |
175 |
|
|
How To Specify No Criteria by
Bobmeister
I am using a form to enable a user to specify criteria for a query. On this
form there are several fields that the user can fill in. I am using these
fields...
|
|
1 |
160 |
|
|
|
|
2 |
280 |
|
|
Query with common fields to all records by
Prohock
I have a query that is collecting information from three tables. One table
has infromation about each student and another table is an incident table and...
|
|
6 |
157 |
|
|
excel calculations in Access by
sdg8481
Hi,
I have a complex query written in Excel which i want to replicate in Access,
however when i do it flags a error message saying undefined functions. So...
|
December 6th, 2009 09:51 AM
by sdg8481
|
7 |
208 |
|
|
Add existing table by
cowichandave
I have an existing query and would like to expand it to include data from
another table not included in this query. I can add it to the existing...
|
|
3 |
123 |
|
|
|
|
4 |
195 |
|
|
How to append running number by
Boon
Hello,
I have a table A. the first field in table A is called ID. the data type is
integer.
I have created a query. In this query I would like to be able to...
|
|
2 |
170 |
|
|
query help by
igg via AccessMonster.com
access 2003:
I need to get to tableC from tableA and TableB. I tried hard to get to TableC
but had no luck.
tableA:
ID N1 N2 N3
1 12 A1 B1
2 12 D4...
|
|
8 |
186 |
|
|
IIf Statement Error by
Mary O[_2_]
I'm trying to formulate an if/then statement in a query and it returns with
error as the value.
I've a calculated expression as Expr2:
Expr2:...
|
|
3 |
182 |
|
|
|
December 5th, 2009 03:43 PM
by DoDev
|
2 |
216 |
|
|
payroll query sample by
Rick Stahl
Does anyone know of a good MS Access payroll system sample I could look at ?
Preferably one that uses promotion dates with new job rates, calculates
employee...
|
|
1 |
125 |
|
|
Not equal to zero by
Jessy MM Jules
Hi
I have access 2007 and have set up a simple table called orders. Within the
table I have set up Order ID, Order Date, Cutomers Name, Total Sales...
|
|
3 |
130 |
|
|
Creating queries asking for counts by
John
I have a database for our hospital diabetes center. We created a great set of
forms etc... to stream line our paperwork, now we need to create some
reports....
( 1 2)
|
|
11 |
309 |
|
|
crosstab query? by
pat67
I use Access to run my pool league. I am trying to get if not a
crosstab query, some query whic will give me one team's wins vs.
another team. Right now I...
|
December 4th, 2009 08:14 PM
by pat67
|
3 |
159 |