Queries

First 10 numbers
I have a query that pulls together states from a program. I group the states and added the Count aggregate to the state field. I want access to display the top 10 states including an extra entry if two states have the same number. I hope this is clear. thank you, -- Deenos ... 27 Apr 2010 14:30

populating a query
hi I think this is a beginner's question, but I'm missing something. Lets say I have a table: empID(pk) Max_ACount 123 5 136 2 154 3 How can I generate this Query? empID ACount 123 1 123 2 123 ... 26 Apr 2010 16:06

Update query question
Hello, I would like to update a record by looking at the value from a form combo box column(1). I have tried Forms![Lab Works Manager]![cmbTo].column(1) but it does not work. The bond column(0) has the ID, but in this case I need to use the actual value from column(1) and not column(0). Any idea how? Thank yo... 26 Apr 2010 21:45

sumif function in Access query, possible?
Hello, I have a query I am trying to calculate the sum of qty if OprStatus equal 1, but there is no sumif function in Access. What can I do to work around it? Thanks ... 26 Apr 2010 16:06

How to make a query sort randomly each time it is run?
I have a webpage that runs a query. Presently I have the top 15 entries always at the top, and any others beneath them. I need to rotate the 15 on top as well as the rest underneath. I know that it is probably a simple sort command but I'm stuck. Anyone able to help me? ... 26 Apr 2010 13:48

Query 90 expiration
I would like to run a qry that will show me when my insurance policyies expire. Some expire in 30 days others in 90. Table: Customers Fields: CustomerName ContactName PolicyNumber PolicyExpirationDate ... 27 Apr 2010 20:13

crosstab for day of week
I have a crosstab query that puts the day of week but I would like it to put each day, Monday thru Friday even if there is no data. How do I accomplish this? Thanks! Kim P -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1 ... 26 Apr 2010 12:38

Search for current date in a text field
I have a SQL database that I have an external data link to an access database. I need to search records based on the current date. The problem is that the field that needs to be searched is in a text format "yyyy-mm-dd". I have used the following statement successfully to pull out current year: Left([ArrestDat... 26 Apr 2010 13:48

Query to see what percentage of people scored a specific number
I am fairly new to access and have created a great database. However the queries are now becomming more complicated than I expected. I have two fields (Goal One and Goal Two) the nurse asks the patient have they met their goal. They use a 1-5 rating scale. 1=no, 2=sometimes, 3=likely, 4=most and 5=always. They ... 26 Apr 2010 12:38

PLEASE HELP: Display current Date & Time in Query Output
Hi All, How can I display current date and time in query output? Is there a way to do this? Thanks in advance ... 26 Apr 2010 10:16