Recent content by KimmieB

I am calling a query from a form that will drop a temporary working table. It re-creates it later in the process. I'd like to first check to see if the table exists to avoid the "table doesn't exist msg". Is the best way to loop through the current databases's tabledefs and check the name or...

Is it possible to use a Case function in a access query? I'm trying to create a update query and I'd like to use a Case function to set the value I'm updating based on another column in the same table. So if I have a table like this: Row Value 1 2 3 I want to update the Value field with 0...

I have an access report that I want to call the "analyze it with Microsoft Excel" option on but I need to do it from VBA so the end users see just the Excel report not the Access report. I'm not sure if this a DoCmd function or not. Any help would be appreciated...

The check box refers to a certain status of records not a boolean value. The label on the check box is "Include Closed Y/N" so if it's not checked then my query needs to have a where clause to select records where the status field is anything but a "closed" status. I know I can fudge it and...

I need to create a query that selects data based on whether a check box on a form is selected or not. Any help is appreciated.

I have a table with fields defined with a percent format and zero decimal positions. After I run the query that populates this table and I open the table, everything look fine; no decimal positions. If I run the query that selects the records in the table everything looks fine; no decimal...

I'm trying to get the latest date in a query using 2 tables with a left join. Can someone explain the difference about when to use the Max function vs. the First or Top 1 when sorting by descending order?

Golum, I'm trying to get the row from table3 where the name matches the empid from table2 where the date is the maximum which would be "duck".

Thanks, I did use that method and it does work but I just thought I was getting overly elaborate and that there was a simpler way. Guess not. Thanks anyway.

Nope, didn't work. I have Access 2002.

I have situation where I have 3 tables in my query. I'm joining table 1 and 2 and selecting the max date in table 2. So far so good. But now I need to join the 3rd table on a column found in table 2. Ex. table1 id 1 2 3 table2 id date empid 1 1/1/2005 123 1 2/1/2005...

I'm trying to create a new report that will be 13" wide on legal paper. I found an existing report that is set up the way but I notice that on the column tab of the Page Setup that the "same as detail" checkbox is checked. On my new report, once I set the width to 13" and try to check this...

yeah! thanks so much!!

Here's my sql: SELECT tbl_loan_review_rem.LOAN_ID, tbl_loan_review_rem.REQUESTOR_FIRST_NAME, tbl_loan_review_rem.REQUESTOR_LAST_NAME, tbl_loan_review_rem.REQUESTOR_COMPANY, tbl_QCREM_list_table.VALUE_DESC AS [Loan Status] FROM tbl_loan_review_rem LEFT JOIN tbl_QCREM_list_table ON...

I have 2 tables in a query using a left join because sometimes the field I'm joining on in Table A has null values. That returns the data I'm expecting but I need to add a where clause to Table B and once I do that I don't get any data. Since it's a left join I'm confused as to why I'm no...