|
|
Display multiple fields in one field by
Ray
I use the following code to display multiple fields in one field
successfully.
Expr2: +", " & +", " &
Results:
Susan Wu, John Ni,
Echo Peng, Chen...
|
November 7th, 2004 04:20 PM
by Ray
|
2 |
330 |
|
|
Recorset or calculated control? by
Crag
I'm trying to create a custom autonumber that increments on a trigger (i.e.
change of name in a text box containing names of staff) so that say 6
records...
|
|
1 |
253 |
|
|
how to get dates for a months and year by
Alex
I need to generate a query with annual sales and with sales per months. I'm
going to create the queries for the total year and months separately and...
|
November 6th, 2004 08:17 PM
by Alex
|
3 |
322 |
|
|
residential question by
BVG HOA
I have a residential database for a Homeowner’s Association and I’m rather
new at this Access thing. I have created a table with lists of unit...
|
|
7 |
210 |
|
|
Help Please by
D
I have:
F1 F2 F3
1 12Oct 2:14
0 12Oct 2:14
0 13Oct 1:15
when is the same day and time I would like a condition that shows just the
record with value in...
|
|
2 |
202 |
|
|
Using multiple checkboxes by
DrEvil
Hi
My problem is this; i got Query (qryETime) that is getting date and name
from form (frmETime) date is date range and name is combo, that all work
fine. Once...
|
|
1 |
357 |
|
|
Combine several fields to one column by
John
I gave a table that contains 7 fields Doctor1, Doctor 2, thru Doctor7
I would like a query that will combine all the fields from the table and
display it as...
|
|
2 |
180 |
|
|
|
|
3 |
157 |
|
|
Part 2 of IIf function by
Jack Houck
Here is my basic IIf function that I'm using.
q05z: IIf(Mid(,1,2)=1,"01"," ")
It's looking at the first 2 spaces and if it's equal to 1
then it puts "01",...
|
|
2 |
183 |
|
|
concat strings on sum query by
Mike
I need to write a sum query however one of the fields needs to be a
concatenation of the detail records.
for example
bob 10
chuck 20
would come back...
|
|
3 |
135 |
|
|
Progressive number by
Student
I've a query that make a progressive number NUM:
Num: (Select Count (*) FROM as AAA WHERE
..)+1
NUM | IDCLIENTE
1 | 1
2 | 3
3 ...
|
November 6th, 2004 08:07 AM
by Student
|
0 |
137 |
|
|
sutting down dvd drivers by
paul
this is the message I get when I start up my computer as
I said I had 2 months problem free until a week ago
A CD-recording driver is installed that might...
|
|
1 |
156 |
|
|
|
|
2 |
224 |
|
|
Transpose like (Crosstab) query by
Lee Hunter
I would like to perfrom a Transpose like query where the intersection is an
actual field rather than an expression.
For example, part, defect and date. I...
|
|
1 |
201 |
|
|
Concatenating Fields by
Jack Houck
Hello,
I'm having problems with an attempt at concatenating fields
in a query.
I have data coming from a link (questions with answers)
that is split up into...
|
|
1 |
213 |
|
|
|
November 5th, 2004 07:10 PM
by FatMan
|
2 |
308 |
|
|
Rank Scorecard Results by
Ndel40
I have a query that creates a scorecard and sorts the results in desending
order. I would like to assign a ranking based on the results. Below is an
exmple...
|
November 5th, 2004 06:35 PM
by Ndel40
|
2 |
248 |
|
|
Automated Email by
Petra
I've created an Outlook email template designed to automatically be sent by
Access, with the requirement that the contents of the email msg populates a
master...
|
November 5th, 2004 06:16 PM
by Petra
|
1 |
154 |
|
|
Identifying duplicates by
Brenda
I am trying to identify duplicate + role for borrowers and
collateral owners. This is not working. How can I code it?
And, what does the HAVING clause do? I...
|
|
1 |
123 |
|
|
|
|
1 |
103 |