Search results

Need some help with yet another rounding issue. The data in bold are the only two pieces of data I have given to me. This in red are calculated through a series of queries. StartDate = 06/09/08 EndDate = 08/01/08 Weeks = 8 TotalDays = 54 TotalWeeks = (54/7) = 7.71 Month1Days = 22 Month2Days =...

Worked like a charm, Thanks.

Oh yeah, that will get me the hours and then subtracting that from the ContactTime it should get me the difference. I will try that out. Thanks.

I need to convert a numeric value into two values (Whole & Part). For example, 2.400 is the numeric value for field ContactTime. I need two seperate numeric values for fields called Hours = 2.000 and Minutes = 0.400. ContactTime is a calculated field that uses the DateDif() between two times...

Aha! Something to remember from now on. I changed it and it now work like a charm. I had just finished my iif() for Section when you gave this to me. It worked but definitely a lot more work. This way is better. Do you know if this forum has a posting of useful functions for Access 2000...

boblarson - Thanks, I have never created a function, but googled it and created one in the module and called it SplitFile. Afterwards i entered the following: Discipline: SplitFile(1,[ASSIGNMENT],"-") I get an error that says "undefined function 'SplitFile' in expression. I used "-"...

I am just not seeing it, maybe it is because I am not a programmer and use the design view to create the query. I am thinking iif() will work, by nesting the left(), mid() and right() and checking for "*-*". So far, this worked for my Discpline seperation. I am now working on the CourseNum...

Kiwiman, the text file is comma delimitted and works for me to get the 1st seperation. I need one more seperation but directed at only one field. RuralGuy, I will try the link and get back to you Thanks.

I have this table (imported from a text file) with a field name called COURSE. The value of course is a text field, with a format of ACCT-101-501. I need to seperate the value into three sections where the delimiter is "-". I currently use Excel to seperate (text-to-column) and then copy it...

Aha! The conversion worked, I now have a total count...Thanks everyone.

Sorry, but Exp1: NZ(FieldName,0) is not giving me numeric values, which is a problem when adding Total: Exp1 + Exp2 to get a total. How do I convert the value to a numeric zero?

I have a database which has two tables (instructional and non-instructional assignments). The Instructional table is a table that is imported from our campus database (data entry done by canpus). The Non-Instructional table is a table that is manually keyed and maintained by me. A faculty...

First question asked and problem solved. Thanks everyone, the Nz() works. I hope all my questions are this easy.

I tried to search to see if this was brought up before, but don't know what this is called. Sorry if this was already solved and hope you can give me the keyword to search. I am working on a query that counts the number of ethnicity responses for each active job posting. We have a online...