|
|
|
September 9th, 2005 03:13 PM
by Al
|
2 |
203 |
|
|
Select in Query causes cartesian results by
Al
I have a query based upon a table (ClientInfo) with 362 rows that because of
a Select statement in one of the Fields it translates to 14560 rows.
Here's what...
|
|
1 |
86 |
|
|
merge data from multiple records by
Al B
I have an access table which has duplicate records with the exception of one
text field which has different data in each record. I would like to combine
the...
|
October 6th, 2006 04:37 PM
by Al B
|
2 |
69 |
|
|
Semicolon delimited text query help by
Al Guerra
I did not design this. I have two tables, table A has a field "Link"
that is of type string and contains a unique 30 character string (700
hundred of them)....
|
|
3 |
1,209 |
|
|
Find Dates Less Than 1 Year Old by
Al H.
I have a date field that I would like to run a query on to
select only those records where the date is less than 1
year old. I appreciate your guidance.
|
August 18th, 2004 05:53 PM
by Al H.
|
2 |
264 |
|
|
|
|
4 |
121 |
|
|
|
|
2 |
94 |
|
|
Bring out the result only once by
Al Mackay
Hi, another query....
I would like to be able to report out either Yes or No whether a
condition exists against a record.
e.g. table exists, as per...
|
|
1 |
147 |
|
|
|
January 18th, 2007 06:11 PM
by AL Rios
|
0 |
93 |
|
|
Query records late to me by
AL Rios
I need urgent help..
I have two fields in my query. They are :
-Duecor (date field)
-Recdate (date field)
I need to know when the records were sent late....
|
December 26th, 2009 03:28 AM
by AL Rios
|
2 |
210 |
|
|
Like Criteria by
Al Smith
I have a query - Contacts - that is used as the basis for a subreport in a
Patient's data report.
The Contacts are imported from Outlook, and linked to the...
|
November 16th, 2007 02:54 PM
by Al Smith
|
0 |
74 |
|
|
Occurs Between two different times by
Al Smith
I am running a diabetes database. Blood sugars are checked at different
times of the day. I wish to say if the time of day is between 8am and
11:30am, then...
|
|
3 |
116 |
|
|
Credit Card Character Count by
AL V
I have a webstore that collects credit card info from
people buying our product. I do not have Credit Card
validation yet on the Webstore. What I do is...
|
|
1 |
436 |
|
|
line numbers by
Al V
Hi,
Have a field for order number. An order can have more
than one line item. How do I create a field called "Line
Number" and force it to start at one and...
|
|
7 |
365 |
|
|
Can't Post Clarification by
Al Voss
Now that my former post has gone through, when I am in other newsgroups
using Outlook Express, I can view all ngs I visit. But I can't post in ANY
of...
|
|
0 |
1,448 |
|
|
I Can't Post by
Al Voss
Although I can view, I can not post in most newsgroups. Please help.
tia,
al
|
|
0 |
1,322 |
|
|
Query using * by
Al-GA
I want to pull a reocds of a same customer from various locations, but the
data is stores as customer name-location in one field. I know there is a way
to do...
|
|
4 |
82 |
|
|
Parameter Query - Chris ?!?! by
al9315
Hope Chris is here - helped before.
You wrote piece of code for me, worked - but when I transfer it to my
database, the line that goes strTrack = "Track" does...
|
February 3rd, 2005 05:32 AM
by Chris2
|
1 |
98 |
|
|
Event Procedure - Stuck !? by
al9315
I am trying to :-
Click Event - InputBox with text to be entered -
then a table is searched for all instances of the text -
Do not have enough coding knowledge...
|
|
1 |
185 |
|
|
Pulling pictures inot a form ? by
al9315
I have a directory on my hard disk, with e.g. 100 pictures. I wish to
allocate e.g. Picture 1 to record 1, Picture 2 to record 17............... in
my...
|
February 24th, 2005 07:03 PM
by
|
1 |
92 |