Search results for query: *

Thank you all for your posts. It is working now. I wanted to randomly select a different Question 1 each time so I had to create a new table with the random order and then apply the statement that PHV gave. Thanks again.

I only want to select one Question 1. For example: Question# Question 1 What is life? 1 Where do you live? 1 Who are you? I only want one Question 1, but I want the question displayed.

I am looking for an inexpensive and secure way to access my files and applications on my work pc from home. I have heard of pc anywhere, but if any of you can give me some other products to try and which ones worked best, I would appreciate it. Thanks.

Hi, I have a query as follows: SELECT DISTINCT Question.[Question Number] FROM Question; Question Number is the only field that I want distinct, but I would like to show 2 other fields that go with Question Number (Question ID, and Question). Any suggestions. This statement doesn't work...

M8KWR, I want to create a test with questions that are selected randomly. My database is created with 5 possible Question 1 questions, 5 possible Question 2 questions, .......... Each question has 4 possible answers, 1 is flagged as correct. The program should randomly select one Question 1...

Hello, I have designed a database to administer an exam. In the database, I have 5 possible choices for Question 1, 5 possible choices for Question 2,.......... What I want to do is have the query randomly select one Question 1, one Question 2......... I have tried using TOP and it does not...

When I do a print in Extra, I periodically get the following error message: The instruction at "0x77f85c41" referenced memory at "0x00000010". The memory could not be written. Any ideas on what would cause this? Thanks.

Hi, I have a form that I have 2 dates on. I am trying to use these dates as criteria for a query: Between [Forms]![Form Name]![Start Date] AND [Forms]![Form Name]![End Date] The query is running as if that criteria statement is not there and it includes...

Tony, I pasted your SQL statement and it does indeed return zero instead of null. Thank you for your assistance.

I tried Tony's code, and it still returns a null for the sum.

Tony, I only want results for totals > 101. The problem is that when there are no totals > 101, I get a null value. I am doing calculations on the value that is in amount donated and when I try to use that filed (amount donated) on a form, I get absolutely nothing. Thanks for your help.

SELECT Table1.[Unique Number], Sum(Table2.[Amount Donated]) AS [SumOfAmount Donated] FROM Table1 LEFT JOIN Table2 ON Table1.[Unique Number] = Table2.[Your Number] GROUP BY Table1.[Unique Number] HAVING (((Sum(Table2.[Amount Donated]))>101)); The code is above. Instead of getting a zero when...

I have a query that is designed as follows (summarized): Table 1 Emp # Table 2 Emp # Amout My query has groupby emp # and sum amount > 101 If there is no amount > 101, the query returns null. I can not display this value on a form or do anything with it. Thanks for your help.

Does anyone know what this error means or how to correct??? Alert Manager Event Interface. Alert Manager Event Interface unable to send alert to \\machine\pipe\AlertManager. Error returned = All pipe instances are busy. Thanks.

Hi, I would like to know if there is a way in Windows 2000 Server to be automatically notified when an account is locked out or there is a logon failure. I know that an event log error is created; but I am looking for an automated process of being notified when the failure occurs. Thanks for...

Hi All, We have some mainframe jobs going through an SNA print server using a compiled Printer Definition file. (PDT) We recently upgraded our server from NT4.0 to 2000. Since the upgrade, our SNA printouts are not using the PDT. They will use whatever font is on the printer (LaserJet 8100N)...

The gateway and the route tables are okay. Anything else to check? Thanks

The problem right now seems to only affect workstation clients. We have a Accelar 1200 Chassis running SW 2.0.7.5 When the problem occurs the symptoms are as follows. 1. The workstation can't route anywhere off the local subnet. 2. You can ping anything in the building. 3. You can't get to...