Recent content by NaderC

I highly doubt it that this is the problem. I think that if that was the case, it would at least generate an error message.

Hi, I have an Access 97 database containing two tables: a linked table, and a local Access table. The link points to an SQL Server 2000 table with 12000+ records. These two tables must stay more or less in sync, so I run a "Find Unmatched" query regularly against the local Access table, so I...

For the fields used by the query, everything is Text. Otherwise all is text except the inventory quantities, which are Number.

Something even more confusing: It seems that this happens only for item numbers that start with 'DIGI'. No other records seem to be affected.

Yep, the same thing happens without the Group By. A larger number of records are returned by the query and therefore a larger number is missing from the result.

The append query is needed because I am appending to a table that contains the history of inventory over time. So every week a dated 'snapshot' of inventory is added to that history table. And as I mentioned before, the problem is in that append query - it doesn't append everything, because it's...

Hi pdx_man, thank you for the reply. This makes sense in some ways, but the problem is, I am generating an Excel report out of this table, and I obviously need all the records to be there. I am using an append query that will take all the records in that query and append them to a table. It...

Hi, There seem to be a serious bug in Access 97, and I want to know if anyone has encountered this before. I tried to describe the problem as best as I can, I also included a flash video to describe everything, here it is: http://naderchehab.googlepages.com/linkedtablebug.swf (~1 MB) My...

Solved I found out that the problem was using LIKE keywords inside IIF statements. I used equal signs instead and it worked.

Hi, I have a table with two fields: CustomerName and OrderNumber. Some order numbers have dashes, for example: 123-4, 123-5, 123-6 etc. I wrote a query to strip those dashes from these ordernumbers, but only for 3 specific customers: Mark, Mike and Jane. This is the query: SELECT...