473,692 Members | 2,230 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Complex query calculating sales - question explained

I tried to be breif and give a scenario so as not to be overlooked because
it was soooo long. Let me give you real world.

I am a manufacturer of goods and produce 11 items that are distributed to
1800 stores of a national home improvement chain store. Every week I
electronicaly receive an excel spreadsheet "inventory report" with 19,800
rows or records, which I import into my tblSalesData table. The table now
has 10 weeks of data or approx 200,000 records.

The reports that are sent have a store number, item number and inventory "on
hand" for each item, each store that is present at the end of that week; no
sales data, no on-order data.

Every week I am also having accounting generate a spreadsheet of purchase
orders receieved which I am importing into another table.

I have what I think is a normalized database with the following table with
the primary in quotes:

StoreInfo: "StoreNum", Address, MarketNum, ManagerName,Con tactName,etc
ProductInfo: "ItemNum", Description, Buypack, UPC code
SalesData: "StoreNum", "ItemNum", "ReportDate ", OnHandQty
POInfo: "StoreNum", "ItemNum", "PODate", PONum, QtyOrdered

What I would like to do is take a 10 week snapshot of all stores, or one
store at a time of inventory levels, and of sales trends. In other words, I
would like to show a store with all 11 items listed in rows, each row
containing 10 columns of data.

For inventory qty's, I think that should be easy enough th pull out with a
query into a form or report since I have the inventory data. So I can see
this.

Store# Item Inventory2/1/06 2/8/06 2/15/06 2/23/06

That will give me a visual of how their inventory looks for a period of
time.

But what I really would like to see is a sales trend. Like:

Store# Item Sales2/1/06 2/8/06 2/15/06 2/23/06

That way, I can visually see which items arent moving in which stores;
identify those stores that have more then one item not performing, and I
also would like to analyze all stores and come up with the least to most
performing stores based on all item in each store, so I can hand thos "bad"
stores off to Customer Service.

How can I calculate sales for a given week. I need something like this:
Find the inventory on the newest report date for store# / item# ; then find
the next newest report date and find the inventory for the same item and
subtract, find the next newest, etc.

I hope that made more sense. Any help or direction will be appreciated. I
am new to access, but have VBA experience with Excel. I am reading "MS
Office Access 2003 Inside Out", John L. Viesas and I will read what the
other poster gave me to read also.

Eventualy I would like to have a report that shows for each store; the
onhand, 8 weeks of sales history, and qty on order, so I can see the health
of each store.

These days, inventory management is the sole responsibility of the supplier
when dealing with this chain, and I want to take the bull by the horn and
make sure our program is successful.

Thank you all.

*************** *************** *************** *************** *************** *

"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:qN******** ************@ka roo.co.uk...
You seem to have left some parts of the transactions out of your
description, do you not take into account purchases or returns (from and
to
stock) for example. How do these shops get their stock?
--

Terry Kreft
"Wired Hosting News" <jt******@hotma il.comwrote in message
news:12******** *****@corp.supe rnews.com...
>Lets say I have 10 products in 10 different stores and every week I get a
report from each store telling me how many items they have left for each
of
>the 10 products.

So each week I enter in 100 records with a store number, item number, on
hand qty, and date of report into my sales data table.

My tables primary is a combo of store# & Item number & Date

After 10 week of this I have 1000 record total with ten unique dates.

How can I figure the sales each week for each item in each store, for eg.

Store# Item# Week1 Week 2 Week 3 etc
1 112 2 0 1

I think this could not be done in a query data view and should be done in
a
>report, but my question is how do I pull the info for each week and
subtract
>it from the previous weeks inventory and then the next...

I would like to be able to view a store, showing all 10 items listed in
rows
>with a column for each weeks sales either in a query dataview or report.
I
>would then like to say " OK, what stores have low sales for many of the
items they carry. " I would like to identify those stores that aren't
performing. A store that hasnt sold anything on 5 of the product for the
last 4 weeks is worse off then a store that hasnt sold anything on two
item
>for two weeks...

Any suggestions?
Does this need to be done in VBA first?

Jul 2 '06 #1
5 3522
Well done.

For you sales, you need to join the inventory table on itself,
with the joins on storenum and itemnum. Alisas the tabkles as CW
(CurrentWeek) and PW (PreviousWeek) you will also need to filter
the second copy to limit the result to the previous week, using
the dateAdd() function as the criteria. I'd put =dateAdd("ww",-
1, CW.ReportDate) in the PW.ReportDate criteria. Your sales is
calculated from the CW.OnHandQty-PW.OnhandQty.

Once that is working to your satisfaction, you'll note that
replenishments will give negative sales numbers. We'll need to
left join what we have to the orders table, I'm unclear as to
how that table is set up, so I'll not offer advice on handling
it yet.

This will give you a query that lists the sales by store, item
and week. You then need to create a crosstab query that shows
the store and item as row headings, the date as column headings
and the sales (calculated above) as value. since you start with
one record per condition anyways, sum, max and avg should all
give the same result for the value.
"Wired Hosting News" <jt******@hotma il.comwrote in
news:12******** *****@corp.supe rnews.com:
I tried to be breif and give a scenario so as not to be
overlooked because it was soooo long. Let me give you real
world.

I am a manufacturer of goods and produce 11 items that are
distributed to 1800 stores of a national home improvement
chain store. Every week I electronicaly receive an excel
spreadsheet "inventory report" with 19,800 rows or records,
which I import into my tblSalesData table. The table now has
10 weeks of data or approx 200,000 records.

The reports that are sent have a store number, item number and
inventory "on hand" for each item, each store that is present
at the end of that week; no sales data, no on-order data.

Every week I am also having accounting generate a spreadsheet
of purchase orders receieved which I am importing into another
table.

I have what I think is a normalized database with the
following table with the primary in quotes:

StoreInfo: "StoreNum", Address, MarketNum,
ManagerName,Con tactName,etc ProductInfo: "ItemNum",
Description, Buypack, UPC code SalesData: "StoreNum",
"ItemNum", "ReportDate ", OnHandQty POInfo: "StoreNum",
"ItemNum", "PODate", PONum, QtyOrdered

What I would like to do is take a 10 week snapshot of all
stores, or one store at a time of inventory levels, and of
sales trends. In other words, I would like to show a store
with all 11 items listed in rows, each row containing 10
columns of data.

For inventory qty's, I think that should be easy enough th
pull out with a query into a form or report since I have the
inventory data. So I can see this.

Store# Item Inventory2/1/06 2/8/06 2/15/06
2/23/06

That will give me a visual of how their inventory looks for a
period of time.

But what I really would like to see is a sales trend. Like:

Store# Item Sales2/1/06 2/8/06 2/15/06 2/23/06

That way, I can visually see which items arent moving in which
stores; identify those stores that have more then one item not
performing, and I also would like to analyze all stores and
come up with the least to most performing stores based on all
item in each store, so I can hand thos "bad" stores off to
Customer Service.

How can I calculate sales for a given week. I need something
like this: Find the inventory on the newest report date for
store# / item# ; then find the next newest report date and
find the inventory for the same item and subtract, find the
next newest, etc.

I hope that made more sense. Any help or direction will be
appreciated. I am new to access, but have VBA experience with
Excel. I am reading "MS Office Access 2003 Inside Out", John
L. Viesas and I will read what the other poster gave me to
read also.

Eventualy I would like to have a report that shows for each
store; the onhand, 8 weeks of sales history, and qty on order,
so I can see the health of each store.

These days, inventory management is the sole responsibility of
the supplier when dealing with this chain, and I want to take
the bull by the horn and make sure our program is successful.

Thank you all.

*************** *************** *************** *************** **
*
*************

"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:qN******** ************@ka roo.co.uk...
>You seem to have left some parts of the transactions out of
your description, do you not take into account purchases or
returns (from and to
stock) for example. How do these shops get their stock?
--

Terry Kreft
"Wired Hosting News" <jt******@hotma il.comwrote in message
news:12******* ******@corp.sup ernews.com...
>>Lets say I have 10 products in 10 different stores and every
week I get a report from each store telling me how many
items they have left for each
of
>>the 10 products.

So each week I enter in 100 records with a store number,
item number, on hand qty, and date of report into my sales
data table.

My tables primary is a combo of store# & Item number & Date

After 10 week of this I have 1000 record total with ten
unique dates.

How can I figure the sales each week for each item in each
store, for eg.

Store# Item# Week1 Week 2 Week 3
etc 1 112 2 0
1

I think this could not be done in a query data view and
should be done in
a
>>report, but my question is how do I pull the info for each
week and
subtract
>>it from the previous weeks inventory and then the next...

I would like to be able to view a store, showing all 10
items listed in
rows
>>with a column for each weeks sales either in a query
dataview or report.
I
>>would then like to say " OK, what stores have low sales for
many of the items they carry. " I would like to identify
those stores that aren't performing. A store that hasnt
sold anything on 5 of the product for the last 4 weeks is
worse off then a store that hasnt sold anything on two
item
>>for two weeks...

Any suggestions?
Does this need to be done in VBA first?




--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 2 '06 #2

Bob Quintal wrote:

Store# Item Inventory2/1/06 2/8/06 2/15/06
2/23/06

That will give me a visual of how their inventory looks for a
period of time.

But what I really would like to see is a sales trend. Like:

Store# Item Sales2/1/06 2/8/06 2/15/06 2/23/06
I am not a big fan of cross tab queries, however, to create a sales
report (query) like the one you described, you might look into cross
tabs. They work great as queries, which export to excel nicely if you
are going to export.

That way, I can visually see which items arent moving in which
stores; identify those stores that have more then one item not
performing, and I also would like to analyze all stores and
come up with the least to most performing stores based on all
item in each store, so I can hand thos "bad" stores off to
Customer Service.
I view this as another report, not to tie into the main one noted
above.

Jul 3 '06 #3
In article <11************ **********@p79g 2000cwp.googleg roups.com>,
no*****@coveyac counting.com says...
>
Bob Quintal wrote:
>
Store# Item Inventory2/1/06 2/8/06 2/15/06
2/23/06
>
That will give me a visual of how their inventory looks for a
period of time.
>
But what I really would like to see is a sales trend. Like:
>
Store# Item Sales2/1/06 2/8/06 2/15/06 2/23/06
I am not a big fan of cross tab queries, however, to create a sales
report (query) like the one you described, you might look into cross
tabs. They work great as queries, which export to excel nicely if you
are going to export.
>
That way, I can visually see which items arent moving in which
stores; identify those stores that have more then one item not
performing, and I also would like to analyze all stores and
come up with the least to most performing stores based on all
item in each store, so I can hand thos "bad" stores off to
Customer Service.
I view this as another report, not to tie into the main one noted
above.

Only thing I can suggest is to google for newsgroup items by "Tom
Ellison" and the keyword Crosstab. Maybe also with Alternative. In his
method the numbers are generated by individual subqueries. In your
example you need 4 subqueries for the "sales" and 4 expressions for the
dates. The good thing is that the initial date could be a date
parameter and the other dates could be calculated from that date. The
sales periods to total would also be gotten from the date parameter.
The query could run for any 4-week period by just asking for the first
date. This is the general concept as I understand it.
Jul 4 '06 #4
Thank you Bob. That worked. As for the orders table, I will ask for
advise when I better know how that will be permanantly set up. I am still a
beginer with Acces.

Since I will be using that sales data on a regular basis and the query does
take some time to calculate the sales data, would it, ad is it possible to
save that query info, the calculated sales data, into a table of its own?
That way I can update that table every week when I import the new weekly
report ( either append the new data or completely rewrite the table.

Does that make sense?
"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .
Well done.

For you sales, you need to join the inventory table on itself,
with the joins on storenum and itemnum. Alisas the tabkles as CW
(CurrentWeek) and PW (PreviousWeek) you will also need to filter
the second copy to limit the result to the previous week, using
the dateAdd() function as the criteria. I'd put =dateAdd("ww",-
1, CW.ReportDate) in the PW.ReportDate criteria. Your sales is
calculated from the CW.OnHandQty-PW.OnhandQty.

Once that is working to your satisfaction, you'll note that
replenishments will give negative sales numbers. We'll need to
left join what we have to the orders table, I'm unclear as to
how that table is set up, so I'll not offer advice on handling
it yet.

This will give you a query that lists the sales by store, item
and week. You then need to create a crosstab query that shows
the store and item as row headings, the date as column headings
and the sales (calculated above) as value. since you start with
one record per condition anyways, sum, max and avg should all
give the same result for the value.
"Wired Hosting News" <jt******@hotma il.comwrote in
news:12******** *****@corp.supe rnews.com:
>I tried to be breif and give a scenario so as not to be
overlooked because it was soooo long. Let me give you real
world.

I am a manufacturer of goods and produce 11 items that are
distributed to 1800 stores of a national home improvement
chain store. Every week I electronicaly receive an excel
spreadsheet "inventory report" with 19,800 rows or records,
which I import into my tblSalesData table. The table now has
10 weeks of data or approx 200,000 records.

The reports that are sent have a store number, item number and
inventory "on hand" for each item, each store that is present
at the end of that week; no sales data, no on-order data.

Every week I am also having accounting generate a spreadsheet
of purchase orders receieved which I am importing into another
table.

I have what I think is a normalized database with the
following table with the primary in quotes:

StoreInfo: "StoreNum", Address, MarketNum,
ManagerName,Co ntactName,etc ProductInfo: "ItemNum",
Description, Buypack, UPC code SalesData: "StoreNum",
"ItemNum", "ReportDate ", OnHandQty POInfo: "StoreNum",
"ItemNum", "PODate", PONum, QtyOrdered

What I would like to do is take a 10 week snapshot of all
stores, or one store at a time of inventory levels, and of
sales trends. In other words, I would like to show a store
with all 11 items listed in rows, each row containing 10
columns of data.

For inventory qty's, I think that should be easy enough th
pull out with a query into a form or report since I have the
inventory data. So I can see this.

Store# Item Inventory2/1/06 2/8/06 2/15/06
2/23/06

That will give me a visual of how their inventory looks for a
period of time.

But what I really would like to see is a sales trend. Like:

Store# Item Sales2/1/06 2/8/06 2/15/06 2/23/06

That way, I can visually see which items arent moving in which
stores; identify those stores that have more then one item not
performing, and I also would like to analyze all stores and
come up with the least to most performing stores based on all
item in each store, so I can hand thos "bad" stores off to
Customer Service.

How can I calculate sales for a given week. I need something
like this: Find the inventory on the newest report date for
store# / item# ; then find the next newest report date and
find the inventory for the same item and subtract, find the
next newest, etc.

I hope that made more sense. Any help or direction will be
appreciated. I am new to access, but have VBA experience with
Excel. I am reading "MS Office Access 2003 Inside Out", John
L. Viesas and I will read what the other poster gave me to
read also.

Eventualy I would like to have a report that shows for each
store; the onhand, 8 weeks of sales history, and qty on order,
so I can see the health of each store.

These days, inventory management is the sole responsibility of
the supplier when dealing with this chain, and I want to take
the bull by the horn and make sure our program is successful.

Thank you all.

************** *************** *************** *************** ***
*
>************ *

"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:qN******* *************@k aroo.co.uk...
>>You seem to have left some parts of the transactions out of
your description, do you not take into account purchases or
returns (from and to
stock) for example. How do these shops get their stock?
--

Terry Kreft
"Wired Hosting News" <jt******@hotma il.comwrote in message
news:12****** *******@corp.su pernews.com...
Lets say I have 10 products in 10 different stores and every
week I get a report from each store telling me how many
items they have left for each
of
the 10 products.

So each week I enter in 100 records with a store number,
item number, on hand qty, and date of report into my sales
data table.

My tables primary is a combo of store# & Item number & Date

After 10 week of this I have 1000 record total with ten
unique dates.

How can I figure the sales each week for each item in each
store, for eg.

Store# Item# Week1 Week 2 Week 3
etc 1 112 2 0
1

I think this could not be done in a query data view and
should be done in
a
report, but my question is how do I pull the info for each
week and
subtract
it from the previous weeks inventory and then the next...

I would like to be able to view a store, showing all 10
items listed in
rows
with a column for each weeks sales either in a query
dataview or report.
I
would then like to say " OK, what stores have low sales for
many of the items they carry. " I would like to identify
those stores that aren't performing. A store that hasnt
sold anything on 5 of the product for the last 4 weeks is
worse off then a store that hasnt sold anything on two
item
for two weeks...

Any suggestions?
Does this need to be done in VBA first?



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 4 '06 #5
"John T Ingato" <jt******@hotma il.comwrote in
news:12******** *****@corp.supe rnews.com:
Thank you Bob. That worked. As for the orders table, I will
ask for advise when I better know how that will be permanantly
set up. I am still a beginer with Acces.

Since I will be using that sales data on a regular basis and
the query does take some time to calculate the sales data,
would it, ad is it possible to save that query info, the
calculated sales data, into a table of its own? That way I can
update that table every week when I import the new weekly
report ( either append the new data or completely rewrite the
table.

Does that make sense?
Yes, it sometimes makes sense to build temporary tables. There
are several options that you could think about.
1) calculate just this weeks data and add it to a permanent
table.
2) Empty the table structure and just append the records.
3) Overwrite the old table with new.

All would be done with simple queries, based on your existing
query,-- an append query for option 1, a delete query and append
query for option 2 and a make-table query for option 3.

Q

"Bob Quintal" <rq******@sPAmp atico.cawrote in message
news:Xn******** **************@ 66.150.105.47.. .
>Well done.

For you sales, you need to join the inventory table on
itself, with the joins on storenum and itemnum. Alisas the
tabkles as CW (CurrentWeek) and PW (PreviousWeek) you will
also need to filter the second copy to limit the result to
the previous week, using the dateAdd() function as the
criteria. I'd put =dateAdd("ww",- 1, CW.ReportDate) in the
PW.ReportDat e criteria. Your sales is calculated from the
CW.OnHandQty-PW.OnhandQty.

Once that is working to your satisfaction, you'll note that
replenishmen ts will give negative sales numbers. We'll need
to left join what we have to the orders table, I'm unclear as
to how that table is set up, so I'll not offer advice on
handling it yet.

This will give you a query that lists the sales by store,
item and week. You then need to create a crosstab query that
shows the store and item as row headings, the date as column
headings and the sales (calculated above) as value. since you
start with one record per condition anyways, sum, max and avg
should all give the same result for the value.
"Wired Hosting News" <jt******@hotma il.comwrote in
news:12******* ******@corp.sup ernews.com:
>>I tried to be breif and give a scenario so as not to be
overlooked because it was soooo long. Let me give you real
world.

I am a manufacturer of goods and produce 11 items that are
distributed to 1800 stores of a national home improvement
chain store. Every week I electronicaly receive an excel
spreadsheet "inventory report" with 19,800 rows or records,
which I import into my tblSalesData table. The table now
has 10 weeks of data or approx 200,000 records.

The reports that are sent have a store number, item number
and inventory "on hand" for each item, each store that is
present at the end of that week; no sales data, no
on-order data.

Every week I am also having accounting generate a
spreadsheet of purchase orders receieved which I am
importing into another table.

I have what I think is a normalized database with the
following table with the primary in quotes:

StoreInfo: "StoreNum", Address, MarketNum,
ManagerName,C ontactName,etc ProductInfo: "ItemNum",
Description , Buypack, UPC code SalesData: "StoreNum",
"ItemNum", "ReportDate ", OnHandQty POInfo: "StoreNum",
"ItemNum", "PODate", PONum, QtyOrdered

What I would like to do is take a 10 week snapshot of all
stores, or one store at a time of inventory levels, and of
sales trends. In other words, I would like to show a store
with all 11 items listed in rows, each row containing 10
columns of data.

For inventory qty's, I think that should be easy enough th
pull out with a query into a form or report since I have the
inventory data. So I can see this.

Store# Item Inventory2/1/06 2/8/06 2/15/06
2/23/06

That will give me a visual of how their inventory looks for
a period of time.

But what I really would like to see is a sales trend. Like:

Store# Item Sales2/1/06 2/8/06 2/15/06
2/23/06

That way, I can visually see which items arent moving in
which stores; identify those stores that have more then one
item not performing, and I also would like to analyze all
stores and come up with the least to most performing stores
based on all item in each store, so I can hand thos "bad"
stores off to Customer Service.

How can I calculate sales for a given week. I need
something like this: Find the inventory on the newest report
date for store# / item# ; then find the next newest report
date and find the inventory for the same item and subtract,
find the next newest, etc.

I hope that made more sense. Any help or direction will be
appreciated . I am new to access, but have VBA experience
with Excel. I am reading "MS Office Access 2003 Inside
Out", John L. Viesas and I will read what the other poster
gave me to read also.

Eventualy I would like to have a report that shows for each
store; the onhand, 8 weeks of sales history, and qty on
order, so I can see the health of each store.

These days, inventory management is the sole responsibility
of the supplier when dealing with this chain, and I want to
take the bull by the horn and make sure our program is
successful.

Thank you all.

*************** *************** *************** *************** *
>>*
*
>>*********** **

"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:qN****** **************@ karoo.co.uk...
You seem to have left some parts of the transactions out of
your description, do you not take into account purchases or
returns (from and to
stock) for example. How do these shops get their stock?
--

Terry Kreft
"Wired Hosting News" <jt******@hotma il.comwrote in
message news:12******** *****@corp.supe rnews.com...
Lets say I have 10 products in 10 different stores and
every week I get a report from each store telling me how
many items they have left for each
of
the 10 products.
>
So each week I enter in 100 records with a store number,
item number, on hand qty, and date of report into my sales
data table.
>
My tables primary is a combo of store# & Item number &
Date
>
After 10 week of this I have 1000 record total with ten
unique dates.
>
How can I figure the sales each week for each item in each
store, for eg.
>
Store# Item# Week1 Week 2 Week 3
etc 1 112 2 0
1
>
I think this could not be done in a query data view and
should be done in
a
report, but my question is how do I pull the info for each
week and
subtract
it from the previous weeks inventory and then the next...
>
I would like to be able to view a store, showing all 10
items listed in
rows
with a column for each weeks sales either in a query
dataview or report.
I
would then like to say " OK, what stores have low sales
for many of the items they carry. " I would like to
identify those stores that aren't performing. A store
that hasnt sold anything on 5 of the product for the last
4 weeks is worse off then a store that hasnt sold anything
on two
item
for two weeks...
>
Any suggestions?
Does this need to be done in VBA first?

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com




--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 4 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1459
by: David Richards | last post by:
Hi, I'm having a problem linking 4 tables in MYSQL. The first table contains customer details, the next item details and the next 2 contain sales information. The final output of the query should be:-
0
1934
by: Dalan | last post by:
I'm not certain if this is doable in the manner explained below, but I'm certain that there have been Access developers who have done something similar. So whatever insight and assistance that can be provided will be much appreciated. There is a separate Update Query (well several) that consolidate various goods from separate tables for access and selection on a sales/order invoice form. The data which is available is the TagNo,...
3
2198
by: Wired Hosting News | last post by:
Lets say I have 10 products in 10 different stores and every week I get a report from each store telling me how many items they have left for each of the 10 products. So each week I enter in 100 records with a store number, item number, on hand qty, and date of report into my sales data table. My tables primary is a combo of store# & Item number & Date After 10 week of this I have 1000 record total with ten unique dates.
5
39237
by: steve | last post by:
Hi All Not sure if this is the right forum, but I need the formula for calculating the amount of Sales tax (GST) from the tax included price In Australia GST is 10% and the standard formula is to divide the total by 11 to get the gst amount This is great until the GST % changes one day
1
1396
by: farazmeghani | last post by:
I have inherited an Access Database when I started working with Ericsson a few months back. I'm currently working on an invoicing report for the invoicing department. Below is a brief example of the kind of data I have: Sales Order Number / Item Ordered / Status 908111 Coaxial Cable C 908111 Adapter C 908111 Transreceiver 908112 Coaxial Cable C 908112 Adapter C 908112 Transreceiver C 908113 Coaxial Cable
6
1609
by: mamusonda | last post by:
I am pretty new to SQL and database concepts. Heres my problem: I have a sales info. table and an expenses info table with invoice number being the field relating the two tables (1:N). The sales table has details about each job done for a specific client, ie. a breakdown of the income recieved from each particular job. Expenses Info. table has several expenses incurred for each job, that is to say, some jobs done require outsourcing which...
2
4314
by: RZ15 | last post by:
Hi guys, I'm really drawing a blank here for how to deal with fiscal months in my monthly sales/receipts reports. My issue is that calculating the months is not as simple as saying 'if the invoice date is january then sum sales' because the first period may include the end of december or even the beginning of february and not all of january. To help me with my problem, it's probably helpful to not think of it as fiscal months but think of...
0
2447
crystal2005
by: crystal2005 | last post by:
Hi, I am having trouble with some complex SQL queries. I’ve got winestore database, taken from Web Database Application with PHP and MySQL book. And some question about queries as the following 1. The wine name, grape variety, year, winery, and region 2. The minimum cost of wine in the inventory 3. The number of bottles available at the minimum price 4. The total number of bottles available at any price 5. The total number of unique...
0
3152
by: Alagas | last post by:
Hi, I'm new to access 2003 & would like to know how to create a report that shows the grand total of counts, details are as the following: 1) I've a database of credit cards where I would like to generate a monthly report for all sales-men & total count of approved cards for each (ex. in AUG). 2) A simple query is created to retreive the required data such as: serial no, sales code & card status(approved only) 2) Then Crosstab query is...
0
8608
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9086
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8806
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7629
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4324
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4557
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2974
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2241
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1959
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.