Hi, I wonder if some one can help me. The following code works: Milestone: IIf(!=100,"Completed",IIf(IsNull(!) And (!=!),"On Target",IIf(!="Sites Closed"...

I have a query that groups failures by audit type. I want it to group only the top 5 failures for each audit type. (not just the top 5...

I need to list the records in one table (8,000 rows) that are NOT in another table (40,000 rows). I tried SELECT ... WHERE NOT IN (SELECT...) but it took...

Hi All, Not sure whether this is query or form related hence the post to both NG's. Hope this is ok. I think what I am doing is pretty basic. I have a...

I'm a little lost and hoping someone can show me the light at the end of the tunnel. I have 2 table 1- General Info 2- Details They have a common thread...

I have a form that allows me to search my table using a number of key words, I also included a button where I could take the search results and put them in a...

Hi, I have a table (Table 1) with three columns of the following type: Example Table1: Col1 - Text Col2 - DateTime Col3 - Memo

How do i get the last dates out of a table in a query My query looks like this Station Code and set number Date off inspection CNC 18 ...

Hello my database looks like Name Age Hello 21 Hi 25 Bye 27 Welcome 16 Say 19 XYZ 18

how do I search for an * in a text field? I mean the character * (ASCII42) rather than a wild card. I've tried 'like chr(42)' in the query parameter but this...

Hello all: I'm trying to do something a little funky here and I'm not sure if I'm approaching it the right way. I'm running an update query that will contain...

a problem to do with bidding on a limited number of items. (simplified form) table1 contains housetype and NumAvailable e.g. type numAvail A 7 B 2 C 5 table2...

Hi My query will output part numbers for labels in ascending order Depending on the number of labels Is it possible to incorporate a flag (***) when the...

I need to be able to INSERT INTO with dynamic sql into a table with an autonumber key field. I have read a number of posts from 1997 to 2001 on Google Groups...

In the QBE Grid, with Like "INT'L" in Criteria, my Query works fine. It fails when I try to create a dynamic Query with this VBA: ' Build criteria string...

Hi Everyone, Using Access 2003 I have Query that has Current Date, PtsOnThpy (num), PtsOnOdrsts (num), Appropriate Thpy Percent which is an expression...

When one gets an error in string manuipulations is it possible to just have access just set it to null some way?

Can anyone show or tell me the basic steps for creating a union query? I'm trying to combine two queries by the PN field. Thanks.

Is there a function that does the opposite of 'In'? i.e. something like: number Not...

Is there an easy way to setup aquery where it will calculate overdue tasks based on the computer date (I don't want to have to go back in and chage the...