Search results

Plog; So, reading this site; it says that IsNull applies to Access 2010, etc.. But what about Visual Basic 2010 Express? Honestly, i'm not sure of the difference - but I had to ask. On the page it gives this as an example: Dim LValue As Boolean LValue = IsNull("Tech on the Net") 'LValue...

The boss gave me a few suggestions and I went to try those (i.e. using IsEmpty or IsNull with an IF statement). Neither option worked. I'm running VB 2010 Express and it did not like either of those two statements. So I have totally abandoned this approach. As I think I mentioned earlier I...

This works if I run a query in access, but VB does not like "Null"

I am trying to modify an existing program and have run into difficulties... I'm new at working with VB but roughly understand what is happening. I'm only having issues with one WHERE clause ... I am pretty sure if I can modify this where clause correctly I can figure the rest of this program...

I have a report that prints out a list of accounting codes. The report appears to be getting its data directly from the accounts table. The final report is similar to this: Account Name.................Account#.........Title Admin............................1000................General Admin...

Liddlem Again, thanks for the suggestion! I was looking at running through this and realized I had attempted this a week or so ago. Or at least a similar approach. I could not get this method to work for me. The problem I ran into was that while I could run a query to get the data I wanted...

This doesnt sound like a bad idea... but sounds like a lot of excess work. Making the table, then you would have to delete the rows from the main table that were copied, then update the temp table, move the temp table data back, ans finally deleting the temp table. It might work... I will...

Plog; I think we've been going about things the same but looking at them differently... I disagree with you; in so far as the data for my expected result IS in my sample data table. But I believe I may see things like you are ... Post #9, sample data - line #4 of data does contain an entry...

Phog; If I want to run a report on 12/1/12 I could at any time I want because the data in the table is stored with the date it was input. Maybe some of the confusion is coming from my field names. ReportDate is the date of the report that generated this list of accounts. The ReportDate is...

plog; First; if it will make things easier; DaysZ does not have to be included in the output. I would like to be able to use the data on the report - but it is not critical in this situation. Response date is the date the customer replied about his/her account with the information stored in...

Let me see if I am totally off track here, or just plane thinking wrong... Here is the query that returns the right information that I want: SELECT Max([ZZZero Testing].Response_Date) AS MaxOfResponse_Date, [ZZZero Testing].[ACCT NUMBER], [ZZZero Testing].UseResponse FROM [ZZZero Testing] GROUP...

Pat ... I agree; That's what got me to come here in the first place :D

You bring up a good point. I'm working with minimal data here, and I think - no, i just confirmed - that you are correct. While my query (in post #10) does give me the correct 7 responses - it does NOT give me the correct data. The date data is correct, but as you mentioned the "response...

CRAP I think I just got it to work!!! SELECT Max([ZZZero Testing].Response_Date) AS MaxOfResponse_Date, [ZZZero Testing].[ACCT NUMBER], [ZZZero Testing].UseResponse, Max([ZZZero Testing].Response) AS MaxOfResponse FROM [ZZZero Testing] GROUP BY [ZZZero Testing].[ACCT NUMBER], [ZZZero...

Phog; Lets try this again... I had to maniplulate a lot of stuff to get this; but here is what I would have... SAMPLE DATASET: ReportDate ACCT NUMBER DaysZ Sent Response_Date Response Notes UseResponse 01-Dec-12 001-005-02-16 25.00 TRUE Testing Data FALSE 01-Jan-13 001-005-02-16 25.00 TRUE...

I thought of doing just a select query as a sub query too, but if you add in the "Response" field into the select query above you get 13 lines back instead of the expected seven. I'm assuming that is because of the differences in the data within that column. As for the final dataset from...

Just FYI - here is some sample data from the table: ReportDate ACCT NUMBER DaysZ Sent Response_Date Response Notes UseResponse 25-Jan-13 001-005-02-16 25.00 Yes 2/1/2013 Test A Testing Data No 25-Jan-13 002-041-01-05 25.00 Yes Testing Data No 25-Jan-13 002-041-01-12 25.00 Yes 2/1/2013 Test C...

plog... I'm very bad at writing SQL queries; 95% of what I do is in design view. When I changed the query in design view from Select to Update the condition of Max(responsedate) disappeared. When I tried to re-add it myself in SQL I received an error of 'invalid characters' As for why I need...

Not really sure why this happens, but I have an update query I would like to run to update a Y/N field. I initially wrote the query as a Select query to test the data results would be what I was expecting. Pretty easy, I just want to see the latest entry by date of an account number's reply...

Testing taptalk access here... Think this works. .. I did some editing today and I think I can make this work! Ive got to figure out the query between select and update, but it should work! Thanks again!