Is the price, quantity and dayprice the same for each tourdate?
do u get the desired results if u place a distinct?
i.e..
SELECT DISTINCT tblTourBookings .TourStartDate
Hi,
Many thanks for your reply.
The DISTINCT bit helped and the price and quantity are the additional costs like ferry crossings which there could be 2 of. Whereas the dayprice is for the tour...
xian2
Last Activity: Apr 19 '07, 09:13 AM
Joined: Nov 29 '06
Location:
-
Haha,
Are there no rules regarding personal banter within posts containing serious questions :-)
Thanks for all your help guys
EddLeave a comment:
-
That code is very long so I thought I would post it as text as well to make it easier to read (well maybe, depending on how you like things)
SELECT tblTourBookings .TourStartDate, tblAdditionalCo sts.Price, tblCostDetails. Quantity, tblToursOffered .DayPrice, [DayPrice]+([Price]*[Quantity]) AS [Total Price]
FROM tblToursOffered INNER JOIN ((tblClient INNER JOIN (tblAdditionalC osts INNER JOIN (tblTourBooking s INNER JOIN tblCostDetails...Leave a comment:
-
Great, worked an absolute treat,
Thank you
EddLeave a comment:
-
Hi,
Sorry I wasnt intending to double post, I started the second post because I was technically asking a second question in the first post so thought it better to start it in a new post for anyone searching in the future.
Sorry, it wont happen again, and thanks for all your great help on all my questions NeoPa and Mary especially.
EddLeave a comment:
-
Hi, the query is:
...Code:SELECT tblTourBookings.TourStartDate, tblAdditionalCosts.Price, tblCostDetails.Quantity, tblToursOffered.DayPrice, [DayPrice]+([Price]*[Quantity]) AS [Total Price] FROM tblToursOffered INNER JOIN ((tblClient INNER JOIN (tblAdditionalCosts INNER JOIN (tblTourBookings INNER JOIN tblCostDetails ON tblTourBookings.TourID = tblCostDetails.TourID) ON (tblAdditionalCosts.AdittionalCostID = tblCostDetails.AdditionalCostID)
Leave a comment:
-
Query showing repeats of the same record
Hi All,
I have created a query with 6 related tables as the record source.
The query includes 4 fields from 4 of the tables:
tblTourBookings
TourStartDate
tblAdditionalCo sts
Price
tblCostDetails
Quantity
tblToursOffered
DayPrice
there is another field in the query which I made up:
Total Price: [DayPrice]+([Price]*[Quantity])... -
Save PDF and Email code error
Hi All,
I have been using this guide http://www.compasscomputing.co.uk/co...DFandEmail.htm to create a command button that automatically saves and e-mails your report and have tried to edit the code, as below (the original code is on his website) but get a load of error messages.
There are only a few bits that need editing (about 6 or 7 little bits) but I still get loads of error messages and if anyone... -
Adding Subreport Subtotals on the main form
Hi,
I have two subreports on my report and they both have a subtotal in the subreport footer section.
I have managed to work out how to call the subtotals in to the main form:
Code:=[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12]
But I have no idea how I add them now.Code:=[Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
... -
Ah, Got it thanks to a friend.
Simple error, the boxes were named Text12 and Text14 not Subtotal1 and Subtotal2. I thought I had renamed them
Here is the finished code for them:
Code:=[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12]
The only problem now is trying to add the two expressions....Code:=[Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
Leave a comment:
-
Hi,
many thanks for your response.
I tried:
Reports!rptInvo ice![tblToursOffered subreport].Report.HasData
But got the value '-1' and was wondering how i complete the expression to get it to equal the value in textbox 'Subtotal1'
Also, how would I get it to total the amount in both subforms?
Subtotal1 + Subtotal2?
many thanks again
...Leave a comment:
-
Problem Totalling Subreport on Main form
Hi All,
I know you have heard this all before from the millions of other people asking the same question, but I have read through many other posts and NeoPa's guide and another guide i found on the internet (http://allenbrowne.com/casu-18.html) but to no avail.
Some background info:
frmTours
Contains 2 subforms (on seperate tabs), one to select the desire Tour Days and the other to select the Additional... -
Two detail section in a report?
Hi All,
I have two lists I would like to include in a report as seperate areas of the invoice.
One list will be a list of tour days selected
The other will be a list of additional costs.
So I would like to have two detail sections if possible:
1
Tour Name Itinerary Price
2
CostName Details Quantity Price
... -
Hi Mary,
I do not think the problem is with the textbox name but more with the control source as there are inconsistencies between the names between the relationships. So the tables are linked via Client ID and ClientID which may cause problems, I do not know.
I am a bit stuck on this and it is really mucking up my system.
Any help muchappreciated .
many thanks
EddLeave a comment:
-
Relationships problem and form / report errors
Hi All,
I have been working on this problem for a while now but have got stuck due to my lack of care in the early stages of database development.
The tables involved in the problem are as follows:
tblClient
Client ID (Note the space)
Title
Forename
Surname
Address1
Address2
Etc…
tblTourBookings
TourID
ClientID ... -
Excellent,
Thank you so much for your help.
Best wishes
EddLeave a comment:
-
Autofit fields in Access
Hi All,
Am trying to create a report and have three fields that need to go next to each other - Title, FirstName, LastName but when they show up on the report the spacing between them in uneven and looks unprofessional.
I was wondering if there is a way of putting them next to each other so they only use the space they need to and have just one space between each.
Also, using design view, I would like... -
Order subform subtotal problem
Hi All,
I am trying to create a subtotal text box much like the one in the orders form of the northwind database where you have a subtotal text box in the footer of the subform and then have that displayed as a text box in the main form.
However, I am having difficulties in doing this and keep getting #Error or #Name? displayed in it.
Any Ideas would be much appreciated.
Background info:... -
Excellent.
ThanksLeave a comment:
-
Hi,
Thank you for your response. I had already set the property to 'No' but it still only shows one record yet the client table shows 12 or so.
Any ideas much appreciated.
Many thanks
EddLeave a comment:
No activity results to display
Leave a comment: