Search results
-
T
format output
I need help to format a cell in a report. The value comes from a linked excel sheet which in its turn gets its info from our business system. When exporting numbers from our business system it has the bad habit of formating numbers into a strange text like form. In excel there is a function... -
T
Need help creating table from excel file
I am stuck with a problem where I need to create a new table from an excel file. In detail my problem is; The excel file contains an order from a customer, like below, BOM Component Qty 123 abc 2 123 def 2 234 ert 1... -
T
Matching two fields in two tables
In a database I have two tables, one is linked to an excel sheet (our customers order) and the other is created via a "make-table query" from our business system. In both tables I have the customers part numbers and neither contain a primary key. What I need to do is compare the part numbers... -
T
Avoid printing the number 0
Smart! Works great. Simple solution. Great! Thanks! twallstr -
T
combo box
In a form I have several combo boxes where the user chooses entries from another table. In the form I have also created links to these other tables so that if an entry is missing the user can got directly to the correct table, edit it, and return to the form and complete it. This all works fine... -
T
Avoid printing the number 0
I have a problem with blank fields being printed in a report as the number 0. This is true only for numbers, not text or dates. How would I do to have those fields printed blank and not with a 0? Thanks! twallstr -
T
background color on report
I have made a simple report where I would like to color the output differently from the column headers like the enclosed jpeg file shows. Nothing in the report will change except the output values under each header. Does anybody know how to do this? Thanks! twallstr