Ok email has been sent (sorry for the delay)
~L~
Al Campagna wrote:
Just click the Contact button. An email will open, zip and attach the file, and
send.
**Let me know in your note what you expect to see for your DSum for each
Registration**
Please include just enough data to do the job... like your Ohio/Americheer example.
Use include the word "Newsgroup" in the subject, and let me know what version your
using.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Al,
Ok I need to get this resolved - I'm going to send you a mock database
- with just one record. The link you have in here is to your website -
are you saying you want me to send to the general email in the contact
tab?
~L~
Al Campagna wrote:
Lisa,
Is this RoomPrice issue, and the forms and tables involved confidential?
You might consider creating a small mdb with just those items we need to test
the
problem, and send that along.
I've been developing Access applications for a living for 13 years now, so
your
data
would be confidential. If the problem is solved, I would delete the file/s.
One last shot...
Is Company really a "text control" on form Reservations... not a combobox or
listbox,
or anything else?
If it is, then...
Try this...
=DSum("[Room Price]","tblAttendees","Company = ' " & [Company] & " ' ")
(I put a space bewteen the quotes for clarity ----> |
|
remove them when trying it out)
It's just another way to express the same DSum. "Any old port in a storm!"
Otherwise, I can only suggest a NEW post, and perhaps someone else can think
of
something I haven't. I know that's a pain. (you can cut and paste alot of your
problem
description from these threads to your new post.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
I would love to send it to you, but I doubt my client would like that
because there is some sensitive data in it. This is not my database, I
just was asked to make some minor changes to the existing. I'm not an
access guru - I'm into SQL so most of my issues are from lack of
experience.
Al Campagna wrote:
Lisa,
OK... that's really clear now! We're getting there...
Everything appears OK from what you've given me so far.
Can you send the file? (see my previous instructions)
I think that would be best, otherwise I'm still guessing as to why a very
simple
DSum
isn't working.
**Also, on my second post I wrote...
(A minor point... please don't delete the previous posts from the thread.
That
way
anyone can see the flow of the problem, and what steps have been covered
already.)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Al,
First of all I want to thank you for your patience - I know this is
becoming frustrating and I appreciate you trying to help me figure this
out. Here are the answers to your question:
1. Is the calculated field (the DSum) on the Main Form? (I assume yes)
What
is
that
field's Name?
Yes. The main form is named Registrations. The text field that I am
using on the main form is txtPackageTotal (and I'm putting the DSum in
it's Control Source)
2. Is Company field on the Main form, or the Subform form?
Registrations has a textbox named Company. The sub form (Attendees)
does not have a textbox named Company - but there is a package drop
down that adds the company name along with the room price (from the
package table) into the Attendees Table.
3. The Main form is named Registrations. If Company is on the subform,
what
is
the
subform Name?
see above
4. Given the sample data you provided would you expect the DSum you
have
now
to
return
$1630 rather than the correct $930.
No, this is what it is doing now - what I need is If I have two records
- Ohio Health & Americheer. When I am in the first record (Ohio Health)
of the Registration form - the txtPackageTotal should be $930. If I go
to the next record (Americheer), txtPackageTotal should be $700.
5. Is the DSum you're looking for independent of any Package differences?
Yes
or
No.
No. There is a different price per package - but the Attendees table
just has the price from the package they picked.
So, in other words:
Main Form=Registrations (Registrations Table)
Sub Form=Attendees (Attendees Table)
Main form has txtbox Company
Sub form has combobox Packages
Attendees Table has Company & Room Price
Registrations Table has Company
Package Table has Package Name & Room Price
txtPackageTotal is on the Main Form
Hope this is what you need?
~L~
