Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sm0wb04rd3r
Starting Member
15 Posts |
 Posted - 2004-01-26 : 11:08:05
|
| Hi there!I have the following problem and no matter how hard I try I just can’t figure out whats the problem! Maybe you could help me in this matter! If you know the solution please help!I have a database with two tables. One is registering the customers. The other their orders. Of course the tables are linked (customer ID). I made a form of the customer table. The customer form also has a subform in which are listed the details of their orders (date of the order, ordered amount, order ID, and the paid amount). When there are no records registered in the orders table (orders subform) the customer form and the order subform looks ok. But as soon as I set an order in the order table and I try to run the customer form the program shows me the following error message: „This expression is typed incorrectly, or it is too complex to be evaluated. For example a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.” Now what the heck is that?? Í just dont get it. I have just 2-3 customers and 5-6 orders. Why is access doing this??? What seems to be the problem??Thanx a lot in advance!! |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2004-01-26 : 11:13:39
|
| Can you post the query your using and hardware software informaion? |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-01-27 : 05:39:34
|
| also....can you write/type out the contents of your input tables....and your expected results.... |
|
|
|
sm0wb04rd3r
Starting Member
15 Posts |
Posted - 2004-01-28 : 05:35:16
|
| Hi!Thanx for beeing helpful!I've been working on the problem and now it works allready! What I did was, I changed the customer_ID in the order table to numeric format, previously was text format.And now it works!Anyway thanx! |
|
|
|
|
|
|
subform problem