Hi everyone ,
I have an urgent report to make in Ms Access and consider me a beginner.
The problem is that I have data in an excel sheet which i have linked in the Access.It is a Pharma data and I have to calculate YTD sales for some Companies.
Its a 37months data and the months are categorized as M1,M2....M37 where M37 is the latest month. so the calulation for ytd would look like as
Ytd for m1, Ytd for m2, Ytd for m3 .... till M12 ,Ytd for m13
m1 m1+m2 m1+m2+m3 m13..
and as the new year starts with M13 it will again resume from the first point when it reaches M25 and would again start from M37 if you consider M1 to be January
I could have hard coded this formulae in MsAccess using normal sum but as it is always a 37 months data and the months move ahead and M1 changes from January to feburary and so the whole coding fails.
Can anyone help me to do this Its really important
Please revert if if you need any more explanation on my part
32  5290   Delerna 1,134
Recognized Expert Top Contributor
If I understand you correctly I must say I don't like it. However I fully understand having to create a solution using the currently used data stores that users insist on keeping.
The way I see it you have a spread sheet where your 37 months are in columns.
This is not ideal for the query you want so you first need to create a query that will convert them to rows. Also since the 37 months are rolling you also need to tag the rows with the correct year and month. Once you have that query the YTD query becomes a simple aggregate query. -
SELECT Now()-day(now())+1 AS Dte, YourLinkedTable.M37 as Qty FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-1,Now()-day(now())+1) AS Dte, YourLinkedTable.M36 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-2,Now()-day(now())+1) AS Dte, YourLinkedTable.M35 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-3,Now()-day(now())+1) AS Dte, YourLinkedTable.M34 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-4,Now()-day(now())+1) AS Dte, YourLinkedTable.M33 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-5,Now()-day(now())+1) AS Dte, YourLinkedTable.M32 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-6,Now()-day(now())+1) AS Dte, YourLinkedTable.M31 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-7,Now()-day(now())+1) AS Dte, YourLinkedTable.M30 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-8,Now()-day(now())+1) AS Dte, YourLinkedTable.M29 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-9,Now()-day(now())+1) AS Dte, YourLinkedTable.M28 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-10,Now()-day(now())+1) AS Dte, YourLinkedTable.M27 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-11,Now()-day(now())+1) AS Dte, YourLinkedTable.M26 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-12,Now()-day(now())+1) AS Dte, YourLinkedTable.M25 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-13,Now()-day(now())+1) AS Dte, YourLinkedTable.M24 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-14,Now()-day(now())+1) AS Dte, YourLinkedTable.M23 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-15,Now()-day(now())+1) AS Dte, YourLinkedTable.M22 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-16,Now()-day(now())+1) AS Dte, YourLinkedTable.M21 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-17,Now()-day(now())+1) AS Dte, YourLinkedTable.M20 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-18,Now()-day(now())+1) AS Dte, YourLinkedTable.M19 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-19,Now()-day(now())+1) AS Dte, YourLinkedTable.M18 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-20,Now()-day(now())+1) AS Dte, YourLinkedTable.M17 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-21,Now()-day(now())+1) AS Dte, YourLinkedTable.M16 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-22,Now()-day(now())+1) AS Dte, YourLinkedTable.M15 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-23,Now()-day(now())+1) AS Dte, YourLinkedTable.M14 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-24,Now()-day(now())+1) AS Dte, YourLinkedTable.M13 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-25,Now()-day(now())+1) AS Dte, YourLinkedTable.M12 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-26,Now()-day(now())+1) AS Dte, YourLinkedTable.M11 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-27,Now()-day(now())+1) AS Dte, YourLinkedTable.M10 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-28,Now()-day(now())+1) AS Dte, YourLinkedTable.M9 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",29,Now()-day(now())+1) AS Dte, YourLinkedTable.M8 FROM YourLinkedTable where company="The Company"
-
UNION ALL
-
SELECT DateAdd("m",-30,Now()-day(now())+1) AS Dte, YourLinkedTable.M7 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-31,Now()-day(now())+1) AS Dte, YourLinkedTable.M6 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-32,Now()-day(now())+1) AS Dte, YourLinkedTable.M5 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-33,Now()-day(now())+1) AS Dte, YourLinkedTable.M4 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-34,Now()-day(now())+1) AS Dte, YourLinkedTable.M3 FROM YourLinkedTable where company="The Company"
-
union all
-
SELECT DateAdd("m",-35,Now()-day(now())+1) AS Dte, YourLinkedTable.M2 FROM YourLinkedTable where company="The Company"
-
UNION ALL SELECT DateAdd("m",-36,Now()-day(now())+1) AS Dte, YourLinkedTable.M1 FROM YourLinkedTable where company="The Company";
-
Now you see why I dont like it, but not using properly designed tables leads to queries like this. Also you will need one of these for each company. If I sat down and thought about it for a bit there is probably a better way but since this is urgent it should work.
Anyway, now you just need an agregate query on that query
I'll assume you call the above query qryDatedDataFor TheCompany -
SELECT year(Dte),sum(Qty) as YTD
-
FROM qryDatedDataForTheCompany
-
GROUP BY year(Dte)
-
You can create a union query of the above from each of the company queries in order to get the YTD results for each company.
Well thats one solution, not very pretty but it should work for you, that is if I understood your post correctly.
Hope it works for you
Sir, first of all Thanks for your reply and I am sorry I got you in this mess.
But there are few questions I need to ask:
Q1 Do I have to replace "YourLinkedTabl e" in your query by the name of the Query from which i am gettting the total months data.(I am actually retrieving this data from another query in which I sumup the monthly sales of each company as the names are repeating)
Q2 Can we use Running sum expression in it?
Also can I send you a mock data?So that it gets easier for us.
I am sorry if I am acting like an idiot.I have been trying to find out a soln to this problem but I havnt been able too.
Delerna 1,134
Recognized Expert Top Contributor
No problems, glad to be of assistance. Thats why I do this.
Q1) I wrote the big query with the assumption that it would be using the linked table that is actually a spreadsheet. And I also had the assumption that the months were horizontal (columns) and the companies where vertical(rows)
like this
......Company.. .M1...M2...M3.. .M4...M5....... .etc
The Company...5.... ...6 ...86....44.... 31
Company Two..12.....34. ..24....37....7 8
If that is so, or as you say there is another query that sums up the data but still looks like that
then yes YourLinkedTable needs to be changed to the name of the linked spreadsheet or the query, whichever applies
Q2) Yes you can get a running sum with modification to the second query
And If the solution I have here isn't quite right, then by all means post mock up data and table structures and we will find a solution
This is absolutely how my Data looks like, but there are certain issues,There are around 173 companies in my database and in your above query I will have to replace "The Company" by the name of a respective company from my database.
Also the next step in this report is to get the YTD (on the similar lines) for the products which are around 1700 in number.
I just had one idea and that can we somehow categorize M1 to M12 as num1 and M13 to M24 as num2 and M25 to M36 as num3 and M37 as num4 (supposedly if M1=Jan and so M37 becomes Jan too) in an excel sheet and linkit in the access and then we can add on the base of these categorizations and everytime a new month arrives we can just change these categorizations ie. M1 to M11 as num1 as now M1 will be Feb and so M36 to M37 as 4.
I hope I am not sounding Crazy :).Its just that I have these ideas but I dont have the programming knowledge to convert them into soutions.
"Thank you so much Delerna for the time you are investing in this."
Delerna 1,134
Recognized Expert Top Contributor
OK so the spreadsheet now looks like this
......Company.. ..Product...M1. ..M2...M3...M4. ..M5........etc
The Company....PROD 1...5.......6 ...86....44.... 31
The Company....PROD 2..12......4 ...43....22.... 20
Company Two...PROD4..12 .....34...24... .37....78
and your summing query looks like this
......Company.. ....M1...M2.... M3....M4...M5.. ......etc
The Company.....17. ....10 ..129....66.... 51
Company Two....12.....3 4....24.....37. ...78
Is that correct?
and we wany to generate the YTD from the summing Query?
We should be able to remove the where clause from the union query.
Exactly thats how I am doing this first I sumup and eliminate repetition and then we calculate the YTD from the monthly sales for both Products and Companies.
Meanwhile I did what you said and I changed the "YourLinkedTabl e" to my query name which is "0_Company_Mont hly_Total_Sum"
Also as you said I removed the where clause so it looks like this
SELECT DateAdd("m",-33,Now()-day(now())+1) AS Dte, 0_Company_Month ly_Total_Sum.M4 FROM 0_Company_Month ly_Total_Sum
union ALL
SELECT DateAdd("m",-34,Now()-day(now())+1) AS Dte, 0_Company_Month ly_Total_Sum.M3 FROM 0_Company_Month ly_Total_Sum
union ALL
SELECT DateAdd("m",-35,Now()-day(now())+1) AS Dte, 0_Company_Month ly_Total_Sum.M2 FROM 0_Company_Month ly_Total_Sum
UNION ALL SELECT DateAdd("m",-36,Now()-day(now())+1) AS Dte, 0_Company_Month ly_Total_Sum.M1 FROM 0_Company_Month ly_Total_Sum;
I copied and pasted it in the SQL view of a new query and tried running it but it is showing an error which is "Syntax error in query expression
' 0_Company_Month ly_Total_Sum.M3 7' "
Delerna 1,134
Recognized Expert Top Contributor
OK, let me go and try this in the mockup database I made last night.
I will be back in a bit
Delerna 1,134
Recognized Expert Top Contributor
This works for me. I have assumed field names Company and Product. You will need to change them if yours are different -
SELECT Now()-day(now())+1 AS Dte,Company,Product, M37 as Qty FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-1,Now()-day(now())+1) AS Dte,Company,Product, M36 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-2,Now()-day(now())+1) AS Dte,Company,Product, M35 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-3,Now()-day(now())+1) AS Dte,Company,Product, M34 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-4,Now()-day(now())+1) AS Dte,Company,Product,M33 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-5,Now()-day(now())+1) AS Dte,Company,Product, M32 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-6,Now()-day(now())+1) AS Dte,Company,Product, M31 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-7,Now()-day(now())+1) AS Dte,Company,Product,M30 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-8,Now()-day(now())+1) AS Dte,Company,Product, M29 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-9,Now()-day(now())+1) AS Dte,Company,Product, M28 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-10,Now()-day(now())+1) AS Dte,Company,Product, M27 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-11,Now()-day(now())+1) AS Dte,Company,Product, M26 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-12,Now()-day(now())+1) AS Dte,Company,Product, M25 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-13,Now()-day(now())+1) AS Dte,Company,Product, M24 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-14,Now()-day(now())+1) AS Dte,Company,Product, M23 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-15,Now()-day(now())+1) AS Dte,Company,Product,M22 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-16,Now()-day(now())+1) AS Dte,Company,Product, M21 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-17,Now()-day(now())+1) AS Dte,Company,Product,M20 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-18,Now()-day(now())+1) AS Dte,Company,Product, M19 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-19,Now()-day(now())+1) AS Dte,Company,Product, M18 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-20,Now()-day(now())+1) AS Dte,Company,Product, M17 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-21,Now()-day(now())+1) AS Dte,Company,Product,M16 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-22,Now()-day(now())+1) AS Dte,Company,Product,M15 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-23,Now()-day(now())+1) AS Dte,Company,Product, M14 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-24,Now()-day(now())+1) AS Dte,Company,Product, M13 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-25,Now()-day(now())+1) AS Dte,Company,Product, M12 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-26,Now()-day(now())+1) AS Dte,Company,Product, M11 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-27,Now()-day(now())+1) AS Dte,Company,Product, M10 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-28,Now()-day(now())+1) AS Dte,Company,Product, M9 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",29,Now()-day(now())+1) AS Dte,Company,Product,M8 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL
-
SELECT DateAdd("m",-30,Now()-day(now())+1) AS Dte,Company,Product, M7 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-31,Now()-day(now())+1) AS Dte,Company,Product,M6 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-32,Now()-day(now())+1) AS Dte,Company,Product, M5 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-33,Now()-day(now())+1) AS Dte,Company,Product,M4 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-34,Now()-day(now())+1) AS Dte,Company,Product,M3 FROM 0_Company_Monthly_Total_Sum
-
union all
-
SELECT DateAdd("m",-35,Now()-day(now())+1) AS Dte,Company,Product, M2 FROM 0_Company_Monthly_Total_Sum
-
UNION ALL SELECT DateAdd("m",-36,Now()-day(now())+1) AS Dte,Company,Product, M1 FROM 0_Company_Monthly_Total_Sum;
-
Delerna 1,134
Recognized Expert Top Contributor
I just had one idea and that can we somehow categorize M1 to M12 as num1 and M13 to M24 as num2 and M25 to M36 as num3 and M37 as num4 (supposedly if M1=Jan and so M37 becomes Jan too) in an excel sheet and linkit in the access and then we can add on the base of these categorizations and everytime a new month arrives we can just change these categorizations ie. M1 to M11 as num1 as now M1 will be Feb and so M36 to M37 as 4.
By the way, this could be done but the if statements to handle it would be horrendous
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ron Adam |
last post by:
Hi, I'm having fun learning Python and want to say thanks to everyone
here for a great programming language.
Below is my first Python program (not my first program) and I'd
apreciate any feedback on how I might do things differently to make it
either more consice, readable, or faster. ie... are there better ways
to do it in Python?
It won't break any records for calculating pi, that wasn't my goal,
learning Python was. But it might...
|
by: Kasp |
last post by:
Hi there,
I am trying to make an OLAP cube on a table having two columns (datetime,
Number_of_times_an_event_occured).
My dimension is time and I want to measure the Min and Max times an event
occured over time.
I have no problem in calculating Maximum occurance of events over time.
However, I have some NULL values in my Number_of_times_an_event_occured
column, due to which I don't see any result when I try to calculate
|
by: Joe Bongiardina |
last post by:
What does the message "calculating...." mean in the lower left status area
of a form?
I have a form with no calculated, concatenated or lookup fields, yet it
displays this msg.
The form takes forever to open and I'm wondering what it's "calculating" and
if that's the
bottleneck.
Thanks.
|
by: jlm |
last post by:
I have a form which feeds table (TblEmpLeave) of Employee Leave Time
(time taken off for Administrative, Annual, Sick, Compensation leave).
I have EmpID, LeaveDate, LeaveType, LeaveHours fields on this form.
Any employee can have multiple entries in the table (key fields are
EmpID and LeaveID) for multiple dates (John Doe can take 3 days annual
leave, then take 3 days sick leave in any given month.
I have a BeginningBalance of hours that...
|
by: robin9876 |
last post by:
In an Access 2000 database on some forms 'Calculating...' is
continuously displayed in the status bar window and the text of the
control is automatically selected.
The only workaround is switching to another application and back
between each field that data is entered.
I have tried this database on pc's that have office 2000 SP1a and
SP3.
How do investigate what is causing this calculating issue and how do I
resolve it?
| | |
by: sugaray |
last post by:
Hi, my problem with calculating the size of an array is when
I pass an array as a parameter to a function which perform the
calculation, the result never comes right, like below:
int SizeOfArray(int a) {
return (sizeof(a)/sizeof(a));
}
main() {
int a={1,2,3};
printf("%d\n",SizeOfArray(a));
|
by: Umesh |
last post by:
i want to calculate the time required to execute a program. Also i
want to calcute the time remaining for the execution of the program.
how can i do that?
pl mention some good websites for learning advanced C.thx.
|
by: laredotornado |
last post by:
Hi,
Can anyone recommend a free script for calculating UPS shipping? I am
familiar with the script written in 2000 by Jason Costomiris, but UPS
is using an XML interface and I wondered if there's anything more
updated.
The pages I located on Google turned up broken links.
Thanks, - Dave
|
by: =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= |
last post by:
Say I have a class like,
class Sample
{
public decimal first = 10;
public decimal second = 20;
}
I have initialized it
|
by: sumit kale |
last post by:
Hi,
Can somebody help me resolve my problem ?
I am getting error when calculating total using unbound textfiled in subform.
I have a main form called purchase_register_master and a subform called purchase_register_details, In sub form i have a unbound textfield called txt_Total_Amount where in i am calculating total amount for different items purchased by giving following code in control source.
ContolSource: =Sum()
In my main form i...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
| | |
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
|
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...
| |
