Queries

Query to create new table format
Hi, I'm trying to make a query that groups a table on 2 columns, then takes all the numbers from 1 of the ungrouped columns and puts them into rows, with a flexible number of rows. I haven't explained this especially well, I'll try posting a the start and end points that I'm look for and hope someone can make so... 24 Jun 2008 12:19

Access 2003 Currency Formatting
Is there a way to format a field in a query to currency and display it like this: -$4,650.00 instead of this: ($4,650.00) ? ... 23 Jun 2008 14:47

Extracting part of a text value
I have a text value that ranges from 5 to 9 characters. The last two characters are always two letters. All of the other characters are always numbers. I want to separate the letters from the numbers - keeping the numbers. I do not need the letters. The "Left", "Right", and "Mid" expressions don't get me w... 23 Jun 2008 13:46

Summarize dates for like records
I have a very large data set with events happening in time steps that are broken down into five minute increments. Over the course of two years the events occur on less than 200 days. I am seeking to query the table for the dates when the events occur. When doing so the query returns with the dates, but the ... 23 Jun 2008 16:51

Date Format
I am working with a government database that has a number field that contains date information formatted to read 20080623. I am trying to get the difference between two dates, but it's showing the difference between 20080313 and 20080417 as 104 days. I've tried a number of fixes shown for others, but I keep get... 29 Jun 2008 09:05

Complicated update
I am helping my brother with his mileage claims database, for under 10K miles you get one rate and another for over 10K. There was a simple update that worked with one exception and that was the job that crossed over from one rate to another. I have written the code below, but Access doesn't like it and after ... 23 Jun 2008 13:46

Summarising a large number of queries
I am trying to create some way of reporting the total values in a large number of Queries. All I need to do is to count the number of records returned by each Query, and then display them in some meaningful format, say in a report or another Query itself. Attempting to do this in a Query or Report so far has b... 23 Jun 2008 11:42

Always Round Down
Hi All, I have a formula in a query that calculates commission. The formula works great however, when there are 3 numbers after the decimal place, in need this number to round down. e.g. $1546.637 needs to round down to $1546.63 Any help would be greatly appreciated. Please! ... 23 Jun 2008 19:56

Parameter Query Problem
This is for a simple database I'm creating at home for my daughter to help her in her college search. I have 5 columns in the DB: College Name, and then four columns listing majors - Animation, Film, Photo, and Video. The College Name column lists the college names. The major columns have a 1 if the college h... 29 Jun 2008 10:06

Update Query question
I'm trying to move 1 record from 1 table to another. The table structures are identical INSERT INTO PATIENT SELECT PATIENT1.* FROM PATIENT1 WHERE (((PATIENT1.IDNUM)=[Enter Patient Number:])); The error states "Function not available in expressions in table level validation expression" What does this ... 22 Jun 2008 21:24