Hi everybody,
How do I create a procedure who
select a random record from
a table.
Table = MyTable
Field = MyField
:-)
/Booty
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10100414.html
Zones:
MS AccessDate Answered: 11/20/1998 Rating: 7.4 Views: 0
I don't know what I'm doing wrong here. When I run this code, I get same record appearing twice. How doI prevent this from happening?
Note: [Case #] is a one to MANY relationship.
===============...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20098507.htm...
Zones:
ASPDate Answered: 04/02/2001 Rating: 6.8 Views: 0
Hi all. Long time no talk to.
I need to understand how to get a distinct list of items when the whole record isn't distinct. For instance. I have a list of Organizations, which are related to...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20587484.html
Zones:
MS SQL ServerDate Answered: 04/17/2003 Rating: 8.6 Views: 0
I am controlling record selection with a list box. My problem is that when I tab through the controls and come to the list box, selection goes to the next record. This happens even when I set "Ta...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20770253.html
Zones:
MS AccessDate Answered: 10/20/2003 Rating: 7.6 Views: 0
Ok, I may be going way out on a limb here but I jsut wanted to see if anyone has done anything like this before. I'm trying to write a stored procedure in SQL 2000 to return a random record but I ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20881713.html
Zones:
MS SQL ServerDate Answered: 02/12/2004 Rating: 9.2 Views: 0
I have a unbound form with a list box. The list box is made from a union query that joins 4 tables. The list box displays formdate and formname, and form id is not shown. I want the user to be ab...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21095608.html
Zones:
MS AccessDate Answered: 08/17/2004 Rating: 9.4 Views: 0
Hi Guys
The best way to explain this is: you know when you run a Form wizard for example and you can select from the available fields to the selected fields, by way way of arrows. Well I would lik...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21197880.html
Zones:
MS AccessDate Answered: 02/06/2005 Rating: 8.6 Views: 0
Hi,
I have a table with 6 fields and I need to calculate a total sum for the top 12 records (from WksOut 52 to 40) of each group of the first two fields combined (Flight and Date) for the fields...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21462475.html
Zones:
MS AccessDate Answered: 06/20/2005 Rating: 7.4 Views: 0
Here, in plain language, is what I want to do with a query:
Select 20,000 random, unique records from a table into another table that has 19,000,000 records where condition A is met.
This i...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_21540611.html
Zones:
FoxProDate Answered: 08/26/2005 Rating: 9.4 Views: 0
Dear experts,
i have a from whose data source is a query. One of the comboboxes (cmb2) on the form displays a list of values that are dependent on another combo boxes value (cmb1). The query re...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21546087.html
Zones:
MS AccessDate Answered: 08/31/2005 Rating: 9.8 Views: 0
