Search results for query: *

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...

I'm trying to write a query that counts the number of records in the table based on the value of specific column. I've tried using Count with the criteria set to "IIF([FieldA] = "apple",1,0) but it's not working. I don't want to just group by FIELDA because I want to explictly create a result...

I'm curious to see if you got this working with Source Safe. I have a similar situation with multiple developers working on an access db. Once it's in VSS, can you check out individual objects like queries and reports?

I know there must be a simple answer to this but for the life of me I can't figure out where\how to change the report layout style of an existing report. When you use the report wizard and choose to group by you can select different layout options (Stepped, Block, Outline1 etc). How do you...

That table won't work. Unlike sys comments in SQL which has the complete text of the stored proc so you can search on a string value, it looks like msysqueries doesn't have the same. I think what I need is a table that contains the SQL view of queries if that makes sense.

I've just inheirited a large access db and I was wondering if there was a way to search the system tables for usage of a specific table\field name in a query. I'v done this with SQL and the syscomments table but access doesn't appear to have an equivilant system table.