Search results for query: *

ac3msm, Your code modification to Is Null worked. Thanks a lot. Regards, greenbird

I get an error message saying: "Invalid use of Is operator in query expression " when i use the IS DBNULL in the following sql statement in asp.net: SELECT SUM(tblDailyHrs.TotSchHrs) AS TotalSch, SUM(tblDailyHrs.TotActHrs) AS TotalAct, SUM(tblDailyHrs.OverTime) AS TotalOt...

Thank you for the tip!! I will give it a try. :)

Thank you cmmrfrds for the tip. If i could let me know how to make the ADO commection to the Excel spreadsheet i would really appreciate that.

Thanks for the help. However i am trying to import the Excel file through VBA, to make a more user friendly interface; and not through the Access menu of File, Get External Data, Import .... Do you have any other ideas?

I am trying to import Excel file into an Access table. each time i do an import, the columns from the Excel file may vary in the number of columns as well as their names. It was suggested that i use the TransferSpreadsheet function in Access using a Temporary table. If you can suggest a...

Can anyone tell me how to create temporary tables in Access?

How do you import an Excel file into an Access table, using code, and where the Excel fields are not constant regarding the total number of fields, and Excel field names may also be changing, from file to file?

Richard, Thank you for your prompt help. This is a good start for me. However, would it be possible for you to show me how these tables would be affected by a journal entry example, lets say using the example shown below: Debit Oct. 22, 2003 Cash $500 Credit Oct. 22, 2003...

Does anyone know how to or have an overview on designing an accounting system, specifically a general ledger or an acccounts receivable system in MS Access?