I have a mail program that uses mml extension. If I rename using dbf extension I can link in access with no problem. Is their a way to instruct access that mml is a Dbase extension?
To build the link table, I use an append query from Table1, and make an expresion field
Date: Int([Table1]![TransDate])
I then update my link table. Since the link table's field is of the date type it puts the correct date in the table.
If I use a select query it returns a numeric value for...
Table1 is a database created by my Accounting program. It puts a date/time for each transaction. Table 2 contains data i have created according to date. (like seasons, week number,physical year, special time frames for my buisness). My goal is to link this info to Excel and to use it's Crosstab...
I'm having trouble figuring out how to make the following link between 2 tables. Table1 has a field with date/time format and Table2 has a field with date format. I want to link the Date portion of Table 1 with the date in table 2. any help would be appreciated
Actually I have the OEM full version of Office. It allowed me to not to install Access 2000, but after install Access 97 was gone, and all the DB files were the access 2000 Icons. I was told by my software vendor if I had installed Access 2000, the only way to get rid of it was by a reformating...
I have an accounting program based on Access 97 file format. All newer versions of Access will convert files to new format and screw up my accounting system. I want to upgrade to newer versions of office without upgrading Access 97. Do I have to buy stand alone version of Excel, word etc.? I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.