Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dinadvani - 28 Feb 2007 11:12 GMT

Hi,

I need your help to build in a form.

I want to build in a form so that it provides mulitple boxes for the reveune
amount and then total amount.

It should include text boxes for revenue where a user enters reveue for a
particular record.

A user can enter amount in Revenue 1, Revenue 2 etc.... But its not sure
whether a record will have 1 revnue entry sometimes the whole revenue related
to 1 record comes a single way and then there are no part payments so only
revenue 1 will be filled in. In some case it would be revenue 2 or 3 as the
case may be.

I hope I am not confusing the reader of this query too much but please excuse
me I am myself confused a bit.

Thanks for your help

Regards,
DA

Reply to this Message

Duane Hookom - 28 Feb 2007 14:50 GMT

You are somewhat confused since your Subject states "Forms", you posted in a
"Report" news group, and you should have posted in a tables design news
group.

You should not have multiple revenue fields. You should have multiple
revenue records in a related table.

Signature

Duane Hookom
Microsoft Access MVP

> Hi,
>
[quoted text clipped - 19 lines]
> Regards,
> DA

Reply to this Message

dinadvani - 01 Mar 2007 06:50 GMT

Thanks for your reply.

But I am not able to get what you are trying to say.

I think I was not that clear in my querry. Below are the details.

I have a form in which I have built a subform so that I can enter the part
payment amount in that subform for the registrations. Eveything on that form
is working properly I am able to enter the part amounts in subform and the
totals are proper. But if this subform has more than 1 entry then the next
form reflects the subform entry again. That means if I have total of 10
entries and of these 10 entries 1 form has 2 part payments and another form
has 3 part payment entries then the total entries in form shows 10+2+3

I don't want the subform details to get repeated again....Please help

Thanks,
D

>You are somewhat confused since your Subject states "Forms", you posted in a
>"Report" news group, and you should have posted in a tables design news
[quoted text clipped - 8 lines]
>> Regards,
>> DA

Reply to this Message

Duane Hookom - 01 Mar 2007 12:05 GMT

Since this is a "report" news group, I would expect to see a mention of
"report" in your message. If you are attempting to create a report, we need
to know something about your tables and records (not mentioned in your
message) and how you want them to appear on your report.

Signature

Duane Hookom
Microsoft Access MVP

> Thanks for your reply.
>
[quoted text clipped - 27 lines]
> >> Regards,
> >> DA

Reply to this Message