Albert D. Kallal
My feedback
-
1 vote
An error occurred while saving the comment -
11 votes
An error occurred while saving the comment Albert D. Kallal commented
A few things. Both the SDK for QuickBooks and also sage is free.
You can download the sage dev kits here:
http://www.sage.com/ca/sage-50-accounting/download/sdk/downloadYou don't need to purchase anything.
Also, keep in mind that Sage uses MySQL - so you can connect to and query the data directly if you wish via standard ODBC and you don't even need to use the above mentioned free SDK for sage.
I used the Sage SDK - it is free and I push invoices from Access using the SDK.
Regards,
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
You have options now to show records vertically. In fact you don’t even need a cross tab. The report wizard normally creating and displays a record “horizontal” or so called “tabular”
However you are free to choose “columnar” which is VERY confusing – since it results in a non-columnar format. I suggest you try the report wizard with columnar – since you don’t have to display each record as a rows, but can display each record like on a form as you are asking.
You might expand on what you are asking - but displaying a record vertically as you ask does not require a cross tab query.
Regards,
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada