heart01
Last Activity: Jul 24 '10, 05:45 AM
Joined: Jun 10 '10
Location:
-
Cheers Jimatqsi, I removed the .qty and .qtyout from the grouping and I am receiving error message stating i tried to execute a query that does not include specified QTY as aggregate function...any heads up on this perhaps -
query for tot
Hello All, I have run into an issue
I have a Product table which captures all incoming stock
I have a Outgoing table which captures all outgoing stock
I have created a query from the product and outgoing tables and in a colum by itself have totalled the amount of stock per product however, what I am needing to see is
1. a report that collates all specific type of stock for example Passenger and...Last edited by NeoPa; Jul 16 '10, 01:03 PM. Reason: Not a problem, but I tidied up SQL and CODE tags -
Well it looks like I have the above issue working now. Perhaps I was too quick to jump into asking...what I did was made a relationship to the product and outgoing tables based on type as this is the field they both have in common. I tried all joins and found one that works. So i dont get duplication now and can select on type which in turn pulls down each outgoing entry for that type and provides a total remaining stock....Leave a comment:
-
a really big thanking you to all...I am the knucklehead from lack of training and understanding. I thank you all for your input and time and efforts.
I think someone mentioned i was male...guess again LOL...kind regards Deb...Leave a comment:
-
data duplication in query
Hi again all, Im starting to feel like i live here...I have an issue with data duplicating in a query. I have been rolling around now for two days and about to throw the computer out. Here goes my issue following.
I have two tables
Product
Outgoing (I have not made a relationship) the only fields the same in these two tables are type and date - further any way i do make a relationship no info displays in the query)... -
Well I think Im totally confusing myself I now have boggled eyes as I am working on trying to update fields and the above automatic calculation anyways I guess what I am trying to do is this
On the form I have the following text boxes
cost per unit
Mark up cost (which is set as format percent)
total with mark up
so what I am trying to achieve is if the user places a figure in the cost per...Leave a comment:
-
calculating a mark up
Hi all seems I need a life but here goes...if i have a field "cost per unit" <--- which is calculated already from dividing the total cost by the qty how can I or can I put in a calulation wherby the user can place say a 30% mark up on the cost per unit and have access automatically calculate...the mark up will be dynamic hope this makes sense
kind regards in advance on your support -
Well it appears that all it working now. I have no idea what I did to get it working however, all calculations are now visible on the form and both queries that I have to use to have the calcs working on the form and the queries for the reports see to be working ... Ill just go back into the database another time just to make sure...thanking you for all help ...kind regards debLeave a comment:
-
to hard basket?...Leave a comment:
-
Yes thank you. I still have not complete understanding of how it all goes together so I appreciate the help...here is the codes for the two queries that have been written...
QUERY ONE
...Code:SELECT [Products_QU_foundationnot in use].ID, [Products_QU_foundationnot in use].[Date Recvd], [Products_QU_foundationnot in use].[Invoice NO], [Products_QU_foundationnot in use].Suppliers, [Products_QU_foundationnot in use].[Product Name], [Products_QU_foundationnot
Leave a comment:
-
hello Colintis I tried your suggestion and I am still having issues...I have played around a little further and now I can see the calculations in the query but all of the other calc on the form have dissapeared (didnt touch any of these on the form) and are showing in the box the "#name?" .. still cannot figured it out my apologies
cheers
debLeave a comment:
-
Issues with aggreagates again
Hi all I received answer previously regarding calculations that show on a form and then in a query. I have everything working on the form showing the calcs and I have used two queries off one another as previously suggest and entered the SQL details as previously suggested everything works excllent. I thought that I had covered everything however, I have to include another field in the table named "power cost per unit" which I have done... -
I appreciate your response - I have the date selection happening but have no idea about linking the selection in the combo box to run and execute the report...I get as far as having the selecton choice available but that is ias far as it goes...Leave a comment:
-
Select a Specific Report to print based on date range
I find myself here again...I am using access 2007 and I have three Reports. What I am thinking I would like to do is have a single list box.combo box? whereby I can select a report and then be able to and or select a date range for that report and then be able to print. I hope this makes sense...
so
select a specific report
Product
Outgoing
Suppliers
enter choose date if... -
Oh by George I think she's got it.....See me doing a little dance...Where do I send the flowers and chocolates?...t hank you so much for all your support and patience...I really appreciate your sharing your knowledge and I hope that I am able to also do this one day...I made a new query and used the second code as suggested from msquared as my grand totals...again thank you thank you thank you...mwahhhLeave a comment:
-
Hello again, Im starting to feel really dumb and I think my hubby is going to throw me out. I have taken all your suggestions above and have succeded in having the calculations show on the report from the query all but two. I am receving the error message Subqueries cannot be used in the expression <expression>. (Error 3203) I think im starting to understand what this is about but I have now been flipping about the search to no avail I have...Last edited by MMcCarthy; Jun 13 '10, 12:39 PM. Reason: Added code tags - see the # icon on posting windowLeave a comment:
-
Hi Jim, I understand that I am in the thick of it and jumpig in at the deep end..I have been doing what you suggested now for the better part of 6 hours and I am clearly not understanding what Im doing. It appears info is just now floating around in my head. I have in the SQL of the query the following;
...Code:SELECT Products.ID, Products.[Date Recvd], Products.[Invoice NO], Products.Suppliers, Products.[Product Name], Products.Type, Products.Size,
Leave a comment:
-
Trying to calculate on query to pull a report
Hello All, I have been trying to work this out myself based on a response that I received yesterday which worked however I think I am lost in the process. I have a form which I have 6 calculated fields plus information fields like date, type etc. However, I now am gravitating to using the Query for these fields to calculate instead of calculating on the form. So simply the fields below are what I have calculated on the form;
Form Field...Last edited by MMcCarthy; Jun 12 '10, 09:17 AM. Reason: added code tags around query - see # icon on posting window -
thank you so much this has worked. It has come in the report as EXPr as a header but I dont mind and will work out how to correct this....thankin g you once again...Leave a comment:
-
Wow, Thank you this does work. I do have a further related question to this if I may.
On the report it is not collating the Type into one single group for example i have about ten listings for Allterrain and alongside each list I have the total for each individual listing. Am I able would you know to group all types and have one complete total for that particular group. I think that would then complete this question.
kind...Leave a comment:
No activity results to display
Leave a comment: