Queries

ORDER BY IIF
Can you use an IIF statement in an ORDER BY statement in SQL? Trying to change the order depending on the if statement? ... 26 Jul 2006 07:24

Date/Time 2400 hour
I figured it out, but I cannot get it to do 24 hour time. I have 99/99/0000\ 00:00;0;_;; example of what I need: 7/23/2006 20:32 not: 7/23/2006 8:32 PM Thx ... 24 Jul 2006 02:22

Using count in a query
I have a query with customer name appearing per order number. How would I get a count of the number of orders per customer so customer name will only appear once and the total number of orders will appear instead of each individual order? KDes -- Message posted via AccessMonster.com http://www.accessmonster.c... 24 Jul 2006 19:25

between time
I have a database that keeps track of student discipline. In it, I have a tbldefaultvalues that contains information that doesn't change that I pull drop down lists from. One field is called "Time" and I have populated it with 15 minute increments from 6:00 AM to 8:00 PM (formatted as medium time). I have a ... 20 Jul 2006 02:10

Correct Profit Margin (%)
Hi Guys, This might be a really dumb question, but can anyone advise the correct way to calculate profit margin % I have [margin]/[cost] i.e ?4.19/6.98 = 60% (no decimals required) Or should it be [margin]/[rrp] i.e. ?4.19/?11.17 = 38% Any suggestions would be appreciated. TIA ... 17 Jul 2006 08:50

Update Query not Updating
I'm trying to update tblEmployees based on the values in tblOptum_NonOps based on a matching employee ID. The query runs, but the update isn't happening - there are no error messages. Here's the SQL UPDATE tblEmployees INNER JOIN tblOptum_NonOps ON tblEmployees.ID = tblOptum_NonOps.ID SET tblEmployees.[New... 12 Jul 2006 19:20

Query for Field Names
I have a Form1 . Have Query1 with Fields named "PKey", "Name", "Tool1", "Tool2", "Tool3". Form1 has CommandButton which opens Query1 using SelectionCriteria. I want to have the user be able to select the name of a Field in Query1 he wants to apply the SelectionCriteria to. I want to display a list of the n... 10 Jul 2006 12:49

Deleting records from one table contained in another?
I am attempting to delete items in one table that exist in another using a delete query and joining the appropriate fields from the two tables. Access is telling me that it cannot delete from these tables. Is there another way to accomplish this? The first table is used to import data weekly and then explanat... 6 Jul 2006 13:53

Turn off Auto Fill In???
Running ACCESS 2000 on XP home. I have a query I run to select a group of records to print a set of product labels. I go through the selected records in the Datasheet view to enter a quantity (qty) of labels I need for each record (1, 2, 3 etc) I skip some records and enter a qty in other. If I enter a sequen... 19 Jun 2006 02:35

DSUM or running total
Hi all, I am an extreme novus with Access. I read every DSUM, running total subject on this board and cant figure out my challenge. Here it is: field1-ssn, field2=amt witheld field3=amt pd. field4=balance I just want to calculate in a very large database, the balance by ssn, and a running total. How do I... 21 Jun 2006 12:43