Jrod2541
Last Activity: Jul 11 '14, 09:06 PM
Joined: Jun 24 '14
Location:
-
Thanks everyone. I used the method twinnyfo gave me and it worked. -
What's happening here is these are the parts(SKU) customers order, I take these parts and choose the vendor(VendrIte m)that sell that part the cheapest(EachCo st).
I already have the cheapest vendor in there as well as the cheapest part, I need to combine the SKUs.
The reason the SKUs are seperated in the first place is because different customers ordered them, but they're still the same parts.
I chose the cheapest...Leave a comment:
-
SQL Combining multiple rows into a single row
So I have a table named Table1. Inside Table1 are the fields: SKU, VendrItem, Qty and EachCost.
...Code:SKU VendrItem Qty EachCost 123 ABC 2 $2 123 ABC 5 $2 475 TGE 4 $9 887 ASW 8 $4 475 TGE 45 $9 788 WQQ 14 $1 475 TGE 20 $9 945 WWT
-
Ok I just looked it up and I fixed it by creating an unbound textbox and in the property sheet under the "Data" tab I have:
Control Source =1
Running Sum Over All
Thanks for the advice and helpLeave a comment:
-
I'm not trying to sound rude or anything but I do need the line numbers to be in correct order. It has nothing to do with preference.
This table is connected to a report which I'd need to print out once this is complete. It needs to show the line number on the left side for each row.
Is there a way I can show the line numbers on a report without using a query?Leave a comment:
-
It is a unique identifier but I don't like using AutoNumber because if I delete a row, than the number skips. Take this table for example:
Now if I want to delete line number 4, then add more rows here's what happensCode:LineNumber B C 1 cd sd 2 cd sd 3 ef df 4 cd gb
...Code:LineNumber B C 1 cd sd 2
Leave a comment:
-
SQL/VBA add row number column
I have this table called: "ABC" and inside it are four fields: "SKU" (DataType: Short text), "VID" (DataType: Short text), "Cost" (DataType: Currency) and "Qty" (DataType: Number).
...Code:SKU VID Cost Qty 123 545 $5 9 123 545 $5 25 145 441 $4 45 488 874 $7 4 474 457 $8 5 145 441 $4 47
-
SQL add date column, change format, and change date
So I'm trying to make a query that adds a column to my table named "Table1". That column's name id "Date". (I'm not sure the syntax to add a DATE/TIME datatype)
After that I'd like to also like to change the format to "yymmdd",Code:ALTER TABLE Table1 ADD COLUMN Date DATE;
, and change the date (or make it default) to what ever the date is.Code:Format(Date, "yymmdd")
...Code:NO
-
It's alright twinnyfo I solved it. Thanks for help anyways. I'll post later explaining what I did, because I don't have a lot of time right now.
Thanks againLeave a comment:
-
Create new table query prompts "Enter Parameter Value"
I'm trying to convert a query I made into a table. This query's name is "VendorOrd" and when I run it everything works fine. There are three fields: Vendor, VendorPriority and SKU.
When I run it, the table looks like this:
...Code:Vendor | VendorPriority | SKU | Date ASDF | 1 | 123 | 140703 ASDF | 2 | 154 | 140703 ASDF | 1 | 541 | 140703 FDSA | 1
-
SQL help
I have four tables: tblOrders, tblSKUItems, tblVendorItems and tblVendors.
Here's my tblOrders table:
...Code:SKU ITEM # VendorOrder 123 124 254 542 324 786 475 521 354 254 128 009 010 704 157 858 821 724 428 129 219 481 484 411 442 754
-
I've deleted the Vendororder field in thetblVendorIte ms table and I put that field in an orders table named tblOrders.
And yes I did create the other two tables for the Vendors and the SKU items, they are called tblVendors and tblSKUItems.Leave a comment:
-
I'm back,
sorry for the late response but here's the table i have:
...Code:ID SKU Vend Pri VItem SameDay VendorOrder 1 123 MDTV 2 4987 Yes 2 123 RYUU 1 464 Yes 3 124 MDTV 2 5001 Yes 4 124 RYUU 1 463 Yes 5 254 MDTV 2 3998 Yes 6 254 RYUU 1 085 Yes 7 542 MDTV 2 5000
Leave a comment:
-
SQL IIf() Function Error
I'm back again. I have a table called tblVendorItem, pretty much exactly the same as twinnyfo's, except I added another field called "VendorOrde r".
But the problem I'm having is when I put this table in a query and run this code in SQL:
...Code:UPDATE tblVendorItem SET VendorOrder = IIf(VendorPriority=1, Vendor, IIf(VendorPriority=2, Vendor, IIf(VendorPriority=3, Vendor, IIf(VendorPriority=4, Vendor, IIf(VendorPriority=5,
-
Thanks twinnyfo, you've been a lot of help.Leave a comment:
-
Thank you so much twinnyfoLeave a comment:
-
Creating a better database
I have this table:
image of my table
That I need split up into three separate tables.
One table for all the vendors (which I've made), though I only have 4 vendors at the moment: MDTV, LOWE, RYUU and GVHH.
One table for all the SKU ITEM #s (I've also made)
And lastly one table for the Vendor item #s.
That last table is tricky because I'm trying to make my database expandable... -
Thanks Rabbit, I'll come back later with three tables
EDIT: I'm not exactly sure how to make a table for Vendor item #s without making Vendor specific fields because some SKU ITEM #s link with multiple vendor Item #s.
Should I just make a list of all the vendor item #s in a single field?
How would I link that field with the sku item #s?Leave a comment:
-
Ok, I know you didn't ask for this but here's a snapshot of a sample table with 4 made-up vendors, I don't think I explained the table well enough earlier but perhaps this will help you further understand:
http://prntscr.com/3wfz6m
If not, I'll look back at the article and try again.
Thanks for your support...Leave a comment:
-
alright, I'm just going to keep working on it, I'll probably be back with more questions.
Thanks for the adviceLeave a comment:
No activity results to display
Leave a comment: