I have a Btrieve dbase which holds our invoice data etc, I have created an access dbase which shows dates and the assoicated period end month. I need to link these tables together based on the invoice date but am having difficulty as I keep getting an ODBC error. They are both date formatted fields (not date/time). Do you have any other suggestions or another way of doing this? Thanks a lot!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking Dates from 2 different databases
- Thread starter KBChristy
- Start date
I don't think access has a date data type, only a dateTime. Don't let the format fool you since this has nothing to do with the data type of the field.
Can the period and month be derived from the data using a formula? You could also use a subreport, where you could write a formula to make the link, but if you need to sort or group on the period, the subreport won't help. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
Can the period and month be derived from the data using a formula? You could also use a subreport, where you could write a formula to make the link, but if you need to sort or group on the period, the subreport won't help. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question