Search results for query: *

This thread is related to thread149-1402780. I had a problem of exporting an Cross-tab report to excel and did not want the export to excel data only option (since I had some cells highlighted in different colors and wanted to retain the cell formatting). I found that if you right-click on the...

OK I have had misinterpreted the end date for the position table. It turns out their is no end date for each position!! In fact, the date I used is a union exit date (which I don't care about). The end date of the position is defined as one day before the start date of the new position...

oops forgot the "and" afterward...don't worry I have tested it and it works SELECT AssignmentPositions.Employee, DMax("Store","Assignment","[Employee]="&[Employee]&" and[StartDate]<=#" & Format([StartDate],"d-mmm-yyyy") & "# and ([EndDate]>=#" & Format(NZ([EndDate],[StartDate]),"dd-mmm-yyyy")...

Alright! I think I got it. I think I should deserve a star for this one (well, most goes to PCLewis) Need to apply another criteria on the DMAX function to equate the employee ids. Need to add addition to DMAX criteria portion of the function: ...

...Employee Store StartDate EndDate Position 1234 AAA 1/01/2000 1/02/2000 Clerk-L1 1235 AAA 1/01/2000 1/02/2000 Manager-L3 * 1234 BBB 14/02/2000 1/06/2000 Clerk-L1 1234 2/03/2001 6/06/2003 Clerk-L2 1234 CCC 6/10/2001 21/12/2001 Clerk-L2 1234...

Similiar thread here: http://www.tek-tips.com/viewthread.cfm?qid=755057

sorry but my assigment table should look like this: Employee Position StartDate EndDate 1235 Manager-L3 Jan.01/00 No enddate for this person's position. He has been a Manager-L3 ever since he started.

...StartDate EndDate Position 1234 AAA Jan.01/00 Feb.01/00 Manager-L3 1235 AAA Jan.01/00 Feb.01/00 Manager-L3 *new 1234 BBB Feb.14/00 Jun.01/00 Manager-L3 1234 Mar.02/01 Jun.06/03 Manager-L3 1234 CCC Oct.06/01...

Thanks again. (I should have tried that - d'oh)

The code below (see code that doesn't work) gives me a error "syntax error in union". Once I click ok it highlight the bracket in ") as Q1". The strange thing is if I break this query apart then it works. There must be something wrong with my syntax surrounding the aliasing. I would like...

Try this: switch( [Cur]="EUR",[Selling Price]*0.6998, true,[Selling Price] ) a switch is like a case statement. This does the follwoing if euro then calculate else (all other currencies) return selling price

I am getting an error when I try this query. I have formatted the query so that I can understand it better. It appears correct but Access is giving me an error "syntax error in union query". Access highlights the left bracket in ") AS Q1" in the union portion of the query. Would you know...

ANOTHER FOLLOW-UP I have been thinking about it this solution and I could really use it in another database (Oracle). I think I may try and update some blank fields using this method. Thanks again PCLewis. I wish I could give you another star!

...YES, the big gap from Dec.21/01 to Oct.31/04 IS INTENTIONAL. This person was not assigned for work in this time period. An the one's marked with "*" are exactly the one's I would want to see. The extra lines is a nice to have but for the time being, could you remove the extra line (ie...

I need a query to populate a column based on criteria in table. The criteria is based on 2 dates. I have 2 tables: employee position table and an assignment table(where the employee is scheduled to work). I need to add another column to the assignment table that displays the person's positon...

A star for you! That is one easy and simple solution! Thanks alot

hilfy, I have done a left outer join but in doing so, it will only return Jack. It should also return Jill since she doesn't have a FIRE certificate (but has a GAS certificate) I think I have to do two queries, one to find who has the certificate and another that takes the results of the...

I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...

GJParker, I have done a left outer join but in doing so, it will return John and Jill. It should not return John since John has a FIRE certificate. It is returning John because he has two other certificates that does not equal FIRE. I have to do two queries, one to find who has the...

I am using crystal 8.5 and need to find persons where a record does not exist. I have two tables, person table and a certificates table. I need to find persons where a certificate does not exist for that person. The certificates table creates records when the person has acquired a...