heckstein
Last Activity: Apr 21 '08, 06:33 PM
Joined: Sep 15 '06
Location:
-
Thank you for the help. I will take that approach since my final output is a report. -
Access query help - results as string or list
I have created a query in MS Access 2003 that is pulling training records for our company that includes training hour calculation. One field I am pulling is the instructor name. Many courses have multiple instructors, which means I am getting multiple records for a single course. I need to capture all of the instructor names, but I only want a single record for each course due to the hour calculation. I would like the report to generate only one... -
As soon as I posted this I realized / figured out that I could >= and <=, so I now seem to have it working....Leave a comment:
-
Date help in Access 2003 query
I am running a query in Access 2003 to pull training courses with a start date that falls within a specified date span such 2/1/07 to 2/28/07. I was using this code - (( I.STARTDATE) Between #2/1/2007# And #2/28/2007#) - but found this excluded courses beginning on the first and last date of my date range. I changed the code to this - (( I.STARTDATE) Between #1/31/2007# And #3/1/2007#) and retreived my missing records, but found I was pulling in... -
No problem and thank you!!!!! It worked and I appreciate it greatly. This forum has been so helpful. As a novice that is forced to learn by trial and error, it is really great to have people like you that are willing to help others. Thanks again....Leave a comment:
-
Thank you! Do I put it in just like this?
SELECT Left(I.LEARNING ACTIVITYCODE,3) AS CATEGORY, I.LEARNINGACTIV ITYTITLE, I.LEARNINGACTIV ITYCODE, I.CODE, I.STARTDATE, I.ENDDATE, I.UNITS, Count(T.ENROLLM ENTSTATUS) AS COMPLETED, I.UNITS*Count(T .ENROLLMENTSTAT US) AS HOURS, Format(I.UNITS* Count(T.ENROLLM ENTSTATUS)/8 AS DAYS, "0000.00"),
T.ENROLLMENTSTA TUSDESCR
I am now getting a syntex error (missing operator)...Leave a comment:
-
Error on query calculation
I am a novice working in Access 2002 trying to run a query I created. I am receiving the error "scaling of decimal value resulted in data trunction", which I have determined is due to this calculation: I.UNITS*Count(T .ENROLLMENTSTAT US)/8 AS DAYS
My query includes 6 joins but it happens with just 1 join or all of them. If I pull this calculation out, it works fine. In design view, I have tried to adjust the decimal property... -
Never mind. I found the LEFT function which appears to be working. Not sure how to delete my original post. Thanks.Leave a comment:
-
How to retreive substring of field in Access 2002?
I am working in Access 2002 and have a query that outputs a course code which is either all alpha or alpha numeric (such as ODLAT or ODLAT1). I want my output to report just the first three alpha characters of the course code (ODE). I tried using SUBSTRING like this: SUBSTRING ( I.LEARNINGACTIV ITYCODE, 1, 3), but received an undefined function error. Can someone provide me with the correct way of doing this. I am a novice. Thank you! -
How to split one data field into 3 and count number of rows in each?
I am working in Access 2002 and trying to create a report from our company's learming management system. I am not a DBA and most of my SQL knowledge has been self taught through trial and error. I have created an access query to track the number of training hours for a training group. The query is working except for one piece of data and I hoping someone can help me. There is a field titled enrollment status, which presents an alpha character of...
No activity results to display
Leave a comment: