L
Liat
Hello,
I have a big table that contains details of prosecutions.
It has the name of the player that sued, his details,
date and there are 5 types of paragraphs:
for each type we have 3 evaluations and 5 payments. Each
one of them has a date and a number. One of the 5
paragraphs has additional details.
I have a form to enter the data to the table - it has a
field for each detail - that means I have (3+5)*5 = 40
fields of dates and 40 fields of numbers.
I have another form - a menu, that the user can choose a
range of dates that - only evaluations or payments that
are between those dates should appear in the report that
is opened after pressing a button.
I made a query using "Or" on all those fields but when I
tried to run it, an error message appeared saying it's
too long.
I understand that I didn't plan it properly - this is my
first project and I learned by myself. I alreay have data
in the big table, I hope they won't have to re-enter it,
BUT the most important thing is to solve the problem.
Thanks a lot,
Liat
I have a big table that contains details of prosecutions.
It has the name of the player that sued, his details,
date and there are 5 types of paragraphs:
for each type we have 3 evaluations and 5 payments. Each
one of them has a date and a number. One of the 5
paragraphs has additional details.
I have a form to enter the data to the table - it has a
field for each detail - that means I have (3+5)*5 = 40
fields of dates and 40 fields of numbers.
I have another form - a menu, that the user can choose a
range of dates that - only evaluations or payments that
are between those dates should appear in the report that
is opened after pressing a button.
I made a query using "Or" on all those fields but when I
tried to run it, an error message appeared saying it's
too long.
I understand that I didn't plan it properly - this is my
first project and I learned by myself. I alreay have data
in the big table, I hope they won't have to re-enter it,
BUT the most important thing is to solve the problem.
Thanks a lot,
Liat