By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Please someone explain to me why

P: n/a
Im developing a database in access about invoices that could use to
different kinds of money (US Dollar and Pesos).

I have a form where you can insert the invoices and de items of de
invoice. I can insert all everything right

Also I made a detailInvoice query that show every invoice item with the
invoice information (invoiceNumber, client, kindOfMoney, idItem,
product, qty, unitaryPrice, totalUSD and totalP, totalItem) where total
is iif(kindOfMoney=USD, totalUSD, totalP) all ordered by idItem

Using this query I made an inform using the assistant and grouping by
invoiceNumber to get a printable version of the invoice, and the
subtotal (sum(totalItem))

The first error is I have is that the items aren't ordered by idItem.

And the other error I have that sometimes I have an #Error in the
subtotal field

I hope someone can help me

Thanx in advance

May 5 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
chucher wrote:
Im developing a database in access about invoices that could use to
different kinds of money (US Dollar and Pesos).

I have a form where you can insert the invoices and de items of de
invoice. I can insert all everything right

Also I made a detailInvoice query that show every invoice item with the
invoice information (invoiceNumber, client, kindOfMoney, idItem,
product, qty, unitaryPrice, totalUSD and totalP, totalItem) where total
is iif(kindOfMoney=USD, totalUSD, totalP) all ordered by idItem

Using this query I made an inform using the assistant and grouping by
invoiceNumber to get a printable version of the invoice, and the
subtotal (sum(totalItem))

The first error is I have is that the items aren't ordered by idItem.

And the other error I have that sometimes I have an #Error in the
subtotal field

I hope someone can help me

Thanx in advance

If you are displaying this in a Report, then sorting the query does
little to nothing. With the Report open in desing mode, click on
Edit/Sorting&Grouping. Define your sorts and groups there.

As far as the #Error message...I wouldn't know why you get it sometimes
and other times not. Obviously something is missing when it doesn't work.
May 5 '06 #2

P: n/a
Thanx, i could order the items of the report

And figured out why the #Error message, it was because i had to change
the grouping summary to the page foot. I solve this using another text
field =[sum of total] but i dont know if it is the best way to solve
this problem

May 6 '06 #3

P: n/a
chucher wrote:
Thanx, i could order the items of the report

And figured out why the #Error message, it was because i had to change
the grouping summary to the page foot. I solve this using another text
field =[sum of total] but i dont know if it is the best way to solve
this problem

Don't know what sumoftotal is. Maybe check out RunningSums in help.
Get to a field, open up the property sheet, and under the DataTab is
RunningSum. Press F1 and read about it.
May 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.