Search results

I want to create a query that will add the values from two rows. The two rows have two attributes that are the same The table is as follows ID InvNumber ItemNumber PaymentNo Amount 1 W123 1 1 100 1 W123 2 1 100 I want to add the amounts and the selection criteria to be based on the InvNumber...

yes to allow me to roll back if there is an error in the processing

Hi guys I'm using the query wizard in access and I'm running the queries using DoCmd.OpenQuery and I was wondering if is possible to use transactions with such queries Cheers in advance

Hi Guys I'm trying to import date from an excel worth sheet into Access but nothing is inserted into the column. The format of the date in excel is 20090128 which is American format and I have also confirmed that the Access uses this to handle dates etc. That data type(in the Access) table...

Thanx for that I gave that a shot earlier on today, I'm getting the following error, "User defined type not" besides calling the function in testit in my code is there anything else I need to do??

Hi I've been trying to create an open file dialog box and I can't get it to pop up. Is there a module I need to create and if so how do I do it. I'm able to import the file using the transferspreadsheet command but I want the user to be able to browse the filesystem and select the file...

Thank you for the help guys managed to use sorting in access to get the required results

Thank you for the response I'm trying to get it to display only the row with the maximun value but I cant seem to get it right, any tips?

Hi I was wondering if someone could assist me in creating a query that will select a row with the highest amount(money) amount duplicate records. This is how it is structured: 1. I have a BatchNumber, ItemNumber and Amount, 2. An item is identified by a combination of the first two columns...