Search results

Hi, I attached a little part of my database. See the query called "Final". When I try to enter the filter criteria in the fields "Begin" or "Mature", I receive that error message. You can experiment by yourselves :)

OK, let's take this problem to another level :) I managed to get rid of those rows where value was equal to '#Error'. However the program still said that 'Data type mismatch in criteria expression'. So in the criteria field I entered this expression: Like #2009.05.31# Now the system didn't show...

Hi, thanks for your advice, it helped. Now I don't see characters " in the criteria field. However still if I press the button "View" the system says that 'Data type mismatch in criteria expression'. Can it be because in some rows, the value of date is '#Error'?

Hi guys, I have a little problem when I try to filter the file by date criteria. Here's what I did: All the data is in text file, so I linked this text file to MS Access 2002, and splited the text file columns. So now I have made a table. The date in this file is like this "2007 05 08", so I...

Ok, the thing is that in the table there is no column which would contain unique data (this time primary key is not a solution). If I combine the values of three columns (Account_no, Currency_name and Customer_ic), then I receive a new value (in the column called Primary key) which is unique...

It's not a primary key. I simply named this column "Primary key" because I'm going to use it in most cases. This is an access DB, but it's located in a remote hard drive. It's not shared.. well, at least I think it's not shared. This file is almost 700 MB of size, so because of storage limit I...

Hi guys, I'm using update query to update values in table. However it takes about an hour to finish updating. I found that there is possibility to use this code to increase the speed of the query: Sub PMUpdate() Dim dbs As DAO.Database Dim rsWk as DAO.Recordset Dim strSQL,i As String Dim...

It's getting more and more interesting :) The function "In" also works as the function "Like". Operators "Not" and "No" do not work. I receive an error message if I use these operators. In my query there are two columns [Expr2] and [Expr8]. First one contains the values of transactions. Second...

Thanks, it helped. Now I'm wondering is there an opposite function for "like"? Let's say I would like to sum all the currencies except USD. If I write a function =DSum("[Expr2]";"Query1";"[Expr8] not like 'USD*'") , then I receive an error. it looks like there is no "not" function in the Access...

Does not help, I really don't understand where is the problem. Maybe Access does not allow to set criterias for expression fields?... However, when I try to make a report all the calculations are OK and look like this: AUD 4500 AUD 2 AUD 100 .. .. USD 200000...

Hey, I need to sum values of currencies in one column (Expr2) considering to which currency I choose (Currency is written in column Expr8). I added a text box In Microsoft Access Form. I entered this formula: =DSum("[Expr2]";"Query1";"[Expr8] = 'USD'") However when I go to the 'Form View'...