Grouping Products In A Report - Please Help
Dec 8, 2007
Hi everyone, I am having a lot of trouble doing something that is probably very simple.
My scenario is customers order products, lots of products, now i need to know the quantities of these products for all my customers. It doesnt have to be by customer name, all i need is the product and the Quantities.
I can produce a Report that contains what i need in it but i would like to summarise it.
My report now has the PRODUCT and the QUANTITY for each product that was entered in the order, Problem is the Same product comes up all the time in the report.
For example Product= Tray Lasagne Quantity = 1
Product= Tray Lasagne Quantity = 2
etc...
And it has a continues list in the report, i would like to group the products so that it shows like this on the report:
Product=Tray Lasagne Quanity= 1, 2 etc
Is this possible? Thanks.
View Replies
ADVERTISEMENT
Jan 5, 2006
Hi everyone,
I have a field in a table on Access 2000 database with takes the following information in any order and can be repeated. e.g. can have 10, etc people with contact signed, 10, etc people with PDD issued, etc.
contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.
I am designing a report in which I want to Group and order the info. in the field in the order shown above, e.g 1. contract signed, then 2. PIN issued followed by PDD issued, etc in Ascending order say and the other way round say CER's issued, EB approved, etc.
Can anyone help here? I have not much experience with designing reports but I have tried using the report Sorting and Grouping and it does it in aphabetical order, not in that order I require.
Thank you
dfuas
View 10 Replies
View Related
Nov 14, 2004
Hi,
I have a problem with the output of a report , i have a couple of tables and
one table here like u can see in this relationship diagram is 'DRA' (attached file) which i want to display the combined results of table 'R' and table 'DO' in the report,although i get the reults into the report of these 3tables starting from --> DRA then table 'R' results followed by the results of table 'DO' , now the problem is its displaying , i would like the display to be like that in the 4th column (as u can see in the pic) , i have tried a lot in the reports but i cant seem to get this output , i would really appreciate the help...
Thank you,
solig.
View 4 Replies
View Related
Dec 27, 2006
First of all, we have a database for all company customer cases (through out the whole year of 2006). Every case has its own priority level.
‘Priority’ column has three option, ‘High’, ‘Medium’, and ‘Low’.
We are new to Access, and we are trying group all the case month to month (group them by their created date) on separate pages. At the end of each monthly summary, we’d like to do a number count on ‘High’, ‘Medium’, and ‘Low’.
Here is a sample that we are trying to get to…
Sample Datebase,
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium
005 11/9/06 Medium
Sample Report we are trying to get to...
Summary for December:
Case #// Created Date// Priority Level
001 12/5/06 High
002 12/7/06 Low
003 12/3/06 High
004 12/1/06 Medium
Total Case: 4
High Priority Case: 2
Medium Priority Case: 1
Low Priority Case: 1
your help will be very appreciated! :rolleyes:
View 1 Replies
View Related
Mar 2, 2013
I am trying to create a report grouped by payment date. The problem I'm having is there are 3 different payment date fields on one table and 1 payment date field on another table. I cannot figure out how to get my group expression to pull up the dates from each one of the fields. Do I need to create a new table for each payment type, or is there a way to create a common field "Payment Date" and pull up date from these 3 fields. I have a criteria form which sets beginning and ending dates, but where to assign it. The report is called "Payments by Date" and I need to show PPD (primary payment date), SPD (secondary payment date), etc.
View 1 Replies
View Related
Nov 8, 2014
I'm trying to create a report with data from 7 different tables. It's supposed to be an assignment overview for a transfer company (driving people from A to B, dunno how to call it in English). I put assignment and customer details into the page header, which is working out fine so far. But now I want to show transfer details and it's proving to be a bit troublesome.
When creating the assignment, the user can choose whether the transfer goes from/to an address or from/to an airport. Depending on which one he chose the data is stored in different tables. To determine whether it is an outward journey/collection, outward journey/target, return journey/collection or return journey/target, I put a field in each of those tables ("Schritt", its value being either 1, 2, 3 or 4).
To visualize I made screenshot of the tables in relationship view, but since I'm a new member i can't seem to post images, so I'm giving you a pseudo URL...
[abload (dot) de (slash) img (slash) transeren40p1r.png]
The final report should look like this:
outward journey
---collection (1)
---target (2)
return journey
---collection (3)
---target (4)
Having the "Schritt" value for each step in either one or another table (address(es) or flight data) is making it a bit hard for me to wrap my head around the problem. Is that doable with expressions or is there a way in VBA to solve this problem?
View 7 Replies
View Related
May 31, 2014
Grouping a report data starting from date 01.04.2013 to 31.03.2014 ??
View 2 Replies
View Related
May 15, 2013
Access 2010. I have a table with the following fields:
- From
- To
- TypeOfWork (to be chosen from a combo-box)
- Activity (text field to be filled in freely)
In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between those times a bit like this:
FROM TO TYPE OF WORK ACTIVITY
00:00 - 11:00 Welding Welding clamps
11:00 - 13:00 Welding Welding anodes
13:00 - 15:00 Cleaning Cleaning pipes
15:00 - 18:00 Cleaning Cleaning floor
I would like it to show in the report like this:
FROM.....TO.......TYPE OF WORK.....ACTIVITY
00:00 - 13:00......Welding............00:00 Welding clamps
...............................................11: 00 Welding anodes
13:00 - 18:00......Cleaning...........13:00 Cleaning pipes
...............................................15: 00 Cleaning floor
So it should sort on "From", then group by "TypeofWork" and repeat the "From" field(I think...). But I now have tried every combination of sorting and grouping I could think of and nothing works!
View 13 Replies
View Related
Dec 2, 2014
I'm trying to group data in a report from single table using grouping and sorting and I want the percentile of every record over group total. I'm using a query to fetch data from table, however I'm unable to get percentage of every single record over group total.
I want to display the report as attached image in single report. I'm unable to get data in "Perc" field. It's populating wrong values.
View 3 Replies
View Related
Apr 23, 2014
I have a table with application records. One of the fields captures schools the applicant will work at. This field stores data in comma delimited format. There could be 1 school name; there could be 5 school names.
My ultimate goal is to build a report which shows me records of all applications, grouped by school choice. I want to see: School A was selected by 5 people, School B was selected by 7, etc.
Is it possible to write a query from this table that will enable this?
View 4 Replies
View Related
Jan 22, 2008
Hi There,
I have created this query and i want to return the top 5 suppliers per LOB. It is returning something but it is not the top 5. I want to limit only to return the top 5. Pls. help and thanks. See attached file.
View 5 Replies
View Related
Aug 17, 2007
Hi, I'm not even sure how to describe my problem in the proper terms in order to look it up in any faq or tutorial.
I have one table, customers. Their name, number, etc.
Another table, products: Name, id, department, etc.
And the final table being orders. Customer bought product when, etc.
However, I'm only able to attach one product to each customer per order. I need to be able to attach any number of products, and I don't know how to go about doing that.
Also, when I create a form for entering all the data to these tables, the information doesn't stick. I create a form using the order table, enter the order and customer information, and have the products as a subform. The information will stick for each table, but they won't connect to each other.
If that makes any sense...
Any pointers would be great thanks, I don't even know where to start.
View 5 Replies
View Related
Dec 2, 2005
I have a form orders with a subform orderdetails where we can order more than one product. When the order is finished you save it with a save button where it will also automathically mark the products ordered as not available.
Now, this code works, the problem is that it only marks one product. how do you make it mark all the products that where ordered (in orderdetails - the subform)? :
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'set values here!
'loop?
Dim stAvai As String
Dim strSetProd As String
stAvai = "= " & Me.OrderDSubform.Form!ProductIdctrl.Value & " "
strSetProd = "UPDATE Products " & _
"SET Products.[Avail]= True " & _
"WHERE Products.[ProductId]" & stAvai & " ;"
DoEvents
DoCmd.RunSQL strSetProd
View 12 Replies
View Related
Apr 19, 2006
I am trying to automate a process where we have 1000's units available on a date eg 01/01/06 - 05/01/06 this is produced in a reprot via a prehistoric system we use.
The report shows the start date and the duration the unit is in use. per each order
I then use excel to populate when the unit is in use. With all of 2006 date's along the top and use an if statement to populate when the unit is in use. Then i sum all like for like units together.
Is there an easy way of doing this in access?
where i am failing is populating when an individual unit is available with out using excel. excell is on the vege of falling over now due to the volume so am desperate for alternatives
View 1 Replies
View Related
Mar 28, 2012
I am using Access 2010. I have 4 columns in my file. They are "Code", "Item", "Qty", and "Amount" . I have 5 products with my own codes. It means the codes are set by me. For example, 00001 for ruler, 00101 for book, 00201 for pencil, 00301 for rubber, 00401 for pen. My wish is to link the code and product together. It means that when I sell a pen, I must type the code for pen (in the "code column") and I must type pen in "Item Column", so I think it really takes long to do this because I will really make a mistake because the code and item are not linked at all. What I mean is that when I fill or know the code, I will get the product automatically in the "Item Column" or vice versa.
Now I have set the code 00401 for pen.
So when I need to fill the information. I wish to fill the code in the "Code Column" and then the word pen is automatically shown in the "Item Column". In this case, I will be able to get right code linked to its product.
View 1 Replies
View Related
May 28, 2006
I would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures.Within my access database i have a link to the product picture stored by filename. I'm looking for an easy solution to do this, i'm using mysql as database on my hosting provider.I can do the export to mysql myself (interfacing between access and mysql) but am looking for some hot software to display the catalog easily without programming the front website myself. I already have oscommerce installed but don't want a webshop and don't know how to disactivate all the features within oscommerce to only retain the article browsing.Thanks if you have a hint
View 3 Replies
View Related
May 29, 2005
Aloha,
it's my first time here and the reason is because i have a problem with a query.
I have a database of a storehouse. Each storehouse can be in one city. Storehouses have 5 products A, B, C, D, and E. A storehouse may have more, less or equal quantities of a product than it needs. I want to write an SQL query that shares the quantities of a product among storehouses. I tried to write but it was to difficult than i thought, so i ask your help. I attach the database for your convinience. :)
View 12 Replies
View Related
May 15, 2014
I have attached a sample database that is for searching products with images. The search works ok, but cant get the product image on form-- FRM_Carns
View 1 Replies
View Related
Apr 16, 2015
I have been trying to get this to work for days and I cant get it to work correctly. I have a query that I need to search only for the records that have 12,22 and 24 so in the fields criteria I have been trying
Total: Where
Criteria: In (12,22,24)
and it works BUT it only works for the first record it finds then it seems to skip and continue to search for all records after that.
View 3 Replies
View Related
Dec 6, 2013
As you know, the prices are, unfortunately, dynamic "objects".
So, I have a table for products:
tblProducts
ID_Product - Autonumber (PK)
ProductName
and a table for prices
tblProductsPrices
ID_ProductPrice - Autonumber (PK)
ID_Product - Number (FK on tblProducts
Price - Double
PriceDate - Date/Time
The problem: I have a certain date. I need to know the available prices at that date for all products.
I have a solution; but, for each product, I apply an external function that use two aggregate functions: DMax and Dlookup.
For my small tables, this isn't a problem but I like to know if it is a better way.
View 10 Replies
View Related
Dec 14, 2006
I have a table with 5 fields:
Build ID Process Product Product_De Operation_
What I am trying to accomplish is as follows:
Each Product can be in the table mulitiple times depending on how many Build ID's it has. So if Product 123456 has Build ID's G004, E818, N005, F813, D024, C879 it will show up one time each for each Build ID. What I want to query is unique Products that are for Build ID's D024 & C879 only and not for G004, E818, N005, & F813.
How can I accomplish this with a query. I am sure I am making this harder than it is but I sure need help.
View 1 Replies
View Related
Nov 21, 2005
Hi,
I'm experimenting with the database attached (Access 2003) and on the Order Deatails subform I would like to be able to view only the products for the related CustomerID!
Any pointers on how to do this - very much appreciated :D !
Thanks,
Mary
(PS Some non-essential db components have been deleted in order to decrease size for upload)
View 4 Replies
View Related
Sep 14, 2014
find only some clients that has only 4 types of products, but no other type of products.
Just to put it in a much easier way to understand. If I have to find only the client that did buy only 1 or more from the 4 products. Fridge, tv, dvd player, mobile phone. But I'm not interested in the clients that also did buy for example, laptop, pc, video cameras, etc. So if the client has only one of the 4 products, I want to list them all, did they buy another type of product too, then not.
How could I create a query that will show me only those clients?
View 4 Replies
View Related
Apr 8, 2013
Finally got my DB straight so I am not using calculated fields however can't figure out the best way to handle the Combo Box so I do not show closed records ( Item checked out and item returned).
Please see the attached table of materials checked out and materials returned. How to setup a query so that if an item has been returned and matches the item checked out, Both the original check-in and the matching return records are filtered and not displayed in the Combo Box.
Also, I am a little worried about partial returns as when an employee only returns half the amount.
View 14 Replies
View Related
Nov 9, 2014
I am trying to make a dsum for products coming in and coming out. find the example below
Products In
Apple 10
Mango 5
Products out
Apple 5
Now I want to show statement for sum as follows
Product. In. Out. Net in hand
Apple. 10. 5. 5
Mango. 5. 0. 5
But it is showing only
Product. In. Out. Net in hand
Apple. 10. 5. 5
what I understand is dsum cannot find the out field for mango as there is no field found for mango
View 14 Replies
View Related
Mar 7, 2013
We have created a database (electrical contractor) of all our customers, invoices, work orders, etc. and been using since 2000. I have created 'not billed' reports and queries for specific types of jobs. Next step for me has been to create a db for our products we purchase from vendors. they can be the same product from different vendors, or same type of product from same vendor but different manufacturer.
We use this to order inventory, check contract prices once we receive invoices from vendor, and provide estimates to our customers so, there are many people looking to search different pieces. I have a good product base entered, and have been looking through sample templates to try to find a way to bring up similar items when you find 'widget1 from vendor1' i would like to click or show somehow 'related items' window?
View 2 Replies
View Related
